What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 81296 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / diptabhaskar ray
the ordering of a table in a database is called index.it
helps in fast access to the specific information.the column
suitable for index should be a primary key or a foreign
key,should be sorted,joins should be allowed and users will
search for data.clustered index and non clustered index.
| Is This Answer Correct ? | 20 Yes | 17 No |
Post New Answer View All Answers
What is the purpose of using pl/sql?
what is online transaction processing (oltp)? : Sql dba
Explain what is an index?
Explain the components of sql?
What view means?
Explain how to use transactions efficiently : transact sql
Can dml statements be used in pl/sql?
What is server name sql?
What is the difference between nested table and varray?
how to shutdown mysql server? : Sql dba
What are the types of records?
How do I pipe the output of one isql to another?
What is trigger and stored procedure in sql?
What is $$ in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
