Dave schrieb:
Hi all,
I've been trying to optimize some of our queries against a large database
and come up against an index problem I haven't been able to find any
documentation on. I've cut the query down to the bare minimum, and found
the following --
explain Select iname,domain,serv,time
Hi,
Thanks for the help; that makes sense I think you guys are right. Is it
worth tuning such a thing? It seems to me like it would be much faster to
use the index?
Thanks again
Dave
Dave schrieb:
Hi all,
I've been trying to optimize some of our queries against a large
database
and come
Hi all,
I've been trying to optimize some of our queries against a large database
and come up against an index problem I haven't been able to find any
documentation on. I've cut the query down to the bare minimum, and found
the following --
explain Select iname,domain,serv,time from log where
what is the total no. of records in the table.
Index will be used , if the query selects between 5 to 10% of the total
records in the table.
If its more than that then, optimizer will doing ALL scan, as it assumes
doing ALL scan is faster than an INDEX SCAN.
On 6/9/08, Dave [EMAIL PROTECTED]