DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.