-
about index on table
hello,
Is there any limit on number of index a table can have?
-
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
-
Forum Rules
|
|