NO. Of Max Indexes per table!How many!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: NO. Of Max Indexes per table!How many!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi!

    Working on Oracle v8i with OS as Win2000/NT.

    Query:

    1.What is the maximum number of Indexes per Table in Oracle.
    2.What is the maximum number of columns per table in Oracle.

    Thanks & Regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    Wink

    Hi
    it is 254 columns is the maximum limit for a table . in version 7.3.4 and i don't know if it is same for 8i

    are u looking for maximum number of columns in an index or maximum indexes for a table ?
    siva prakash
    DBA

  3. #3
    Join Date
    Feb 2001
    Posts
    286

    Hi prakashs43

    Hi prakashs43!

    Thanks for the reply!


    are u looking for maximum number of columns in an index or maximum indexes for a table ?

    Reply:I am looking for both!

    And maximum number of columns per table!

    Regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    Talking


    pls note the change . number of columns is 1000 columns in a table in 8i version

    Oracle7 Server Reference Book, Chapter 5, Database Limits
    =======================================

    object Limit
    ----------------------------------------------------
    index(or cluster index) 16 columns maximum
    table 254 columns maximum


    Oracle8 Server Reference Book, Chapter 5, Database Limits
    ========================================

    object limit
    ----------------------------------------------------------
    table 1000 columns maximum
    indexed 32 columns maximum
    (or clustered index)
    bitmapped index 30 columns
    siva prakash
    DBA

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