Results 1 to 2 of 2

Thread: about index on table

  1. #1
    Join Date
    Feb 2005
    Posts
    7

    about index on table

    hello,
    Is there any limit on number of index a table can have?

  2. #2
    Join Date
    Mar 2003
    Posts
    468
    There is no limit to the number of indexes your table can have.

    The only real limit is determined by the number of columns in the table. Oracle will not let you create two indexes that have the same column list.

    For example.
    if you have table T(col1, col2)
    you can have indexes
    (col1)
    (col2)
    (col1,col2)
    (col2,col1)
    and that is all

Posting Permissions

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