how many indexes can be created for a table?
Answers were Sorted based on User's Feedback
Answer / satish
we can create 16 indexes
1 primary index
15 secondary indexes
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / abc
we can create 16 indexes
1 primary index
15 secondary indexes
Is This Answer Correct ? | 11 Yes | 3 No |
Answer / guest
Maximum 15 indexs are created for table
By,
Sathish.
Bhelssia
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / pradeep upadhyay
one clustered and unlimited non-clustered indexes can be
created in a table.
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / shailendra
I have created 35 indexes in one table in sql server 2000.
Is This Answer Correct ? | 0 Yes | 7 No |
how to handle double click event in table contorl....
What is database utility? : abap data dictionary
What is the difference between RETURNING and CHANGING parameters for a method?
WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY WHILE UPDATING THE DATABASE TABLES?
wat is RFC?wat r the RFC types?
What is SQL Trace, how would you carried out performance analysis of ABAP code using SQL Trace? Give the steps?
what is the difference between view and join
2-What is the difference between At New and On change Of inside a loop??I want inside a loop difference not basic difference??
What are the steps to execute session method?
Differentiate between table and template ?
What is meant by performance analysis?
For a package or transaction we will be having multiple no of user exits .Out of these exits how we will find out that the particular exit is the exit which we have to code