Subject | Re: best query to find the first row ordering by a column, with a constraint |
---|---|
Author | korkless |
Post date | 2010-03-02T08:57:51Z |
the query execution time now is less than 1/4 of previous :)
i understand why use an index also in source_id (there're about 200 different source ids), my question was why i need to order also by source-id desc but i think that i must read more on how multiple index works to udnerstand it.
anyhow thanks all, now the responce time is perfect.
i understand why use an index also in source_id (there're about 200 different source ids), my question was why i need to order also by source-id desc but i think that i must read more on how multiple index works to udnerstand it.
anyhow thanks all, now the responce time is perfect.