NO. Of Max Indexes per table!How many!

[amitstora]

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.

[prakashs43]

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 ?

[amitstora]

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.

[prakashs43]

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