DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2001


    Does composite indexes require more space during index creation than a single column index? If yes how?

    Something is "bugging" me out.
    When I tried to create a composite index on three columns I ran out of space. But if I use the same storage parameter to create a single column index, I do not run out sf space.

  2. #2
    Join Date
    Apr 2001
    Yes, a composite index will take up more space, becuase of more data. Now, does it grow expoentially? I do not know.
    Applications come and go,
    but the data remains!

  3. #3
    Join Date
    Oct 2001
    Toronto, Canada
    Hello! Composite index would have to have more than one column and will require space for all teh columns plus a bit of overhead vs single column index which needs storage for one column and some overhead.


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.