quote:
As for a hidden clustered index that is not true. The table remains in a heap with no logic order. When the Non-Clustered index is built it will have the column data for each occurrance and will have thefile and page number with it to know where to look for the value.
I think, I know what the dba meant.
If you create a nonclustered index and don't already have a clustered index, SQL Server has to create a 'phantom' clustered index anyway because nonclustered indexes always point to clustered index keys. So you might create your own clustered index , ensuring that it will be of some use.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]