finding space for primary keys
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: finding space for primary keys

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Exclamation

    Hello,
    I'm trying to find information(space usage information of my primary keys) in order to be able to monitor space usage of all my primary keys. Can any one tell me how I can do that?

    still learning,
    learn

  2. #2
    Join Date
    Sep 2000
    Posts
    96
    Try analyzing the index for the primary key then query the index_stats view and you can look at the used_space column.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width