What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79120 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
Are there any features that are decommissioned in 11g that are not present in 11g?
Is left join same as inner join?
What is the difference between count 1 and count (*) in a sql query?
How many sql core licenses do I need?
How do I create a sql database?
What are the types of optimization?
What is the difference between alter trigger and drop trigger statements?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How do I order by ascending in sql?
What is crud diagram?
what is the difference between blob and text? : Sql dba
What is a unique constraint?
What is pl sql variable?
Explain select statements in sql?
How do you update sql?
