|
![](/i/fill.gif) |
>> I hadn't considered the possibility of the entire table data being in
>> the index itself. That would move the tipping point somewhat...
>
> Not the entire table, just the columns required by the query in question.
Right, that's the other point I overlooked - you might not actually want
every single column in the table for a given query.
So, now that we've got all that out of the way, I'm sure you'll agree
with me that there are times when you do *not* want to use an index,
even if there is one. ;-)
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
![](/i/fill.gif) |