| Subject | Re[2]: [ib-support] Strange query problem |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2003-02-14T17:53:55Z |
At 11:12 AM 2/12/2003 -0400, Daniel Rail wrote:
the time to the first record more than the total time, then
using the index is quicker. If you care more about the time
the whole query takes, then sorting is faster.
Regards,
Ann
www.ibphoenix.com
We have answers.
>If you want the result set ordered, I think it's quicker to use an"Quicker" is in the eye of the beholder. If you care about
>index to sort
the time to the first record more than the total time, then
using the index is quicker. If you care more about the time
the whole query takes, then sorting is faster.
Regards,
Ann
www.ibphoenix.com
We have answers.