What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79183 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rm thirunavukkarasu
Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.
There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index
For more info adt sql plz visit www.thiruna.blog.com
| Is This Answer Correct ? | 8 Yes | 16 No |
Answer / sandip kumar chaturvedi
index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.
| Is This Answer Correct ? | 20 Yes | 33 No |
What is trigger and types?
Why do we use sql constraints?
What are the packages in pl sql?
How to load data with sql*loader?
Which is better join or subquery?
What is sql analyzer?
What will be the output for the below Query Select 'High' from dual where null = null;
What is oracle sql developer?
How do you use join?
What is mutating error in pl sql?
What is mutating trigger?How to avoid it??
Write one update command to update seqno field of a table on the basis of row number.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
