Optimizing Multiple ORDER BYs
Posted by:
Sep Si
Date: June 25, 2009 07:50PM
I have a relatively small table (250k rows) which grows at about 500/day.
It has a bunch of columns, but in this case the important ones are:
valid tinyint
language_ID smallint
linkval1 tinyint
linkval2 tinyint
....
....
...
The query is basically: "SELECT ..., ..., ... FROM `table` WHERE valid=1 AND language_ID=x ORDER BY linkval1 DESC, linkval2 DESC
Unfortunately searching around for advice on multiple order bys but have some up with nothing. Anyone have advice on what index would be best to create?
Subject
Views
Written By
Posted
Optimizing Multiple ORDER BYs
11460
June 25, 2009 07:50PM
3612
June 27, 2009 12:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.