"Invisible" <voi### [at] devnull> wrote in message
news:4891b12a$1@news.povray.org...
> I still think if you have a huge table with an index in just one field,
> full-scanning the table would be faster than an index scan if you're
> processing a very large percentage of the table's rows. But apparently
> that's just me. :-}

Ah, but read again. The clustered inde (or index-organised table) is an
index that has ALL of the data at the leaf level of the index. In essence,
it is the table.
So, if the index is the table, and you scan all the leaf pages of the index
.......

> BTW, what does "<g>" mean? I always thought it was short for "Gail" or
> something, but that doesn't make much sense...

Short hand for <grin>

Post a reply to this message