What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 79303 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 do you mean by query optimization?
Can we perform dml on view?
What is before and after trigger?
What are the advantages of sql? Explain
How many types of primary keys are there?
Is record in pl sql?
What is sqlerrm?
Explain the components of sql?
Can we insert data into materialized view?
What is a string data type in sql?
Explain the difference between drop and truncate commands in sql?
Is delete faster than truncate?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Enlist the advantages of sql.
Explain the uses of control file.
