ORDER BY - where put indexes 1

[nego78]

Hi

i must sort this way

ORDER BY IF((Katalog_NowaOcena > 0 && Katalog_OcenaIlosc > 0),(Katalog_NowaOcena*Katalog_OcenaWartosc/Katalog_OcenaIlosc),IF(Katalog_NowaOcena > 0,Katalog_NowaOcena,(Katalog_OcenaWartosc/Katalog_OcenaIlosc))) DESC

where i should put indexes to reach max preformance (medium database - 200k records)

thanks in advance

Webdesign

 

[TonyGroves]

There will be no indexes used there, so there will be no advantage in setting up any. If speed is, or is likely to become, a problem, then you might consider adding a field to your table containing the result of that calculation, and index that.