Re: Assessment question on indexes

"Gump" <stoopidstoopidstoopid_at_hotmail.com> wrote:
> Hypothetically if the index skip scan feature was not available, what
> would the correct answer be?

Still a). That option would not be using the index as an index, but as a skinnier version of the table. Therefore there is no necessity of using the leading edge columns, whether skip-scan is available or not.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB