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
- 83820 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
Does mysql support pl sql?
discuss about myisam index statistics collection. : Sql dba
What is bind reference and how can it be created?
define sql delete statement ? : Sql dba
What are few of the schema objects that are created using PL/SQL?
Does sql*plus have a pl/sql engine?
Does sql use python?
What is the maximum number of columns in sql table?
How delete all data from all tables in sql?
give the syntax of grant and revoke commands? : Sql dba
Explain about various levels of constraint.
What is pivot query?
How do I remove all records from a table?
What is a table in a database?
Explain what is a field in a database and record in a database?
