DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: finding indexes larger than tables

Hybrid View

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    finding indexes larger than tables

    I recently stumbled upon a situation where my index was much larger than
    my table, does anybody have a query I can use to find ther similiar situations.

    This needs to work for all combinations of partitoned and non partioned
    tables and indexes

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Objects that consume space require segments. Segments have a type and size. So you find all indexes for a table. Compare sum of one index against the sum of the table.

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