Re: doubt on order of table scan

"News" <news_connection_at_yahoo.fr> wrote in news:dirj4h$oj1$1_at_aphrodite.grec.isp.9tel.net:

> I don't know what matters but if I were who implement it I would sacn
> in the order of the indexed column if an index is used or in the order
> of page chains if it's scan without an index.
>

Which index is used if more than 1 index exists?

What happens if the index is on a NULLable column?

So the most correct answer is "From the inside outwards!". Received on Sat Oct 15 2005 - 14:35:37 CDT