On Sep 13, 2008, at 4:39 AM, Tomasz Ostrowski wrote:
On 2008-09-12 15:52, Jack Orenstein wrote:Sorry, I misspoke. I have an index, but preferred doing a scan without the index in this case.Why?The only reason I can think of is that you'd like to avoid disk seeking. But you get at most 1 row in 30 seconds, so disk latency (only several milliseconds) can be ignored.
Because other parts of our application consume results from the same query at normal speed.
Jack
