November 28, 2003 at 12:24 pm
Hi All, I need your help again. How can I determine the number of records in a table that are indexes? How can I identify which of all these records of the table are indexes? Thanks for your support. Regards. jperez@saljamex.com
November 28, 2003 at 1:02 pm
What????
Each row in a table is a 'table row'. Unless we don't speak of a clustered index for each row in the table there is also a row in the index, but it's stored in a different physical location.
Can you explain what you mean?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 28, 2003 at 1:03 pm
To add to the above, this is only true if there is an index on the table at all.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 28, 2003 at 1:08 pm
I guess you meant wich columns have indexes on them.
With sp_helpindex TableName, you can see this.
If you have primary keys with clustered indexes, you also can use sp_pkeys TableName.
December 1, 2003 at 3:48 am
if you want to get information about all your indexes (regardless if they are primary keys, unique keys or simple indexes) take a look at:
http://www.sqlservercentral.com/scripts/contributions/246.asp
best regards,
christian.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply