How many different types of indexes we have in oracle?
- 24 Answers
- 185667 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / vipul.solanki
Index is use for the performance to retrieve data from table.
1 . index automatically created when create PK or UK
2 . Explicitly create index
there is three type of index
1.unique index
2.cluster index
3.non-cluster index
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to install oracle odbc drivers?
What is a table index in oracle?
What are the data types in oracle?
What are the differences between char and nchar in oracle?
What is flashback in Oracle?
Differentiate between post-database commit and post-form commit?
What is the Tune Query
What's dateware house and what's clustor with practicle example
How to return top 5 rows in oracle?
How to open and close an explicit cursor in oracle?
How to export your own schema?
What is data block in Oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
How to grant create session privilege to a user in oracle?
What is an oracle cursor variable?
