What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 81321 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 update query?
What are the query optimization techniques?
Which are the different types of indexes in sql?
What is Overloading of procedures ?
What is Raise_application_error ?
Is not null in sql?
What is pls integer?
What is set transaction?
Can we join more than 2 tables in sql?
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
How do we tune the code?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
