Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 83357 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / deepa
A table can have any number of indexes. However, the more indexes there are, the more overhead is incurred as the table is modified. Specifically, when rows are inserted or deleted, all indexes on the table must be updated as well. Also, when a column is updated, all indexes that contain the column must be updated.
| Is This Answer Correct ? | 8 Yes | 11 No |
Post New Answer View All Answers
how to include comments in sql statements? : Sql dba
Is sql better than excel?
Do prepared statements prevent sql injection?
how to create a new table in mysql? : Sql dba
How can we optimize a sql query?
What is dynamic sql in pl sql?
What is the difference between in and between in sql?
Can you sum a count in sql?
How do I truncate a sql log file?
What schema means?
What is foreign key and example?
What is an invalid partition table?
Can we use having without group by in sql?
What is sql data?
What is trigger types in sql?
