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
- 84286 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
Which is better cte or subquery?
Explain cursor types?
What is a memo field?
What are the sql aggregate functions?
what is transaction? : Sql dba
Explain architecture of sql server notification services?
what are null values? : Sql dba
What makes a good primary key?
What are the types of subqueries?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Which sql most popular?
Explain what is a view?
Explain two easy sql optimizations.
What is a function in oracle pl sql?
what are the differences between require and include, include_once and require_once? : Sql dba
