Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to have a minimum number of indexes?
- 1 Answers
- 983 Views
- I also Faced
- E-Mail Answers
Answer / Kush Kant Srivastava
You may want to have a minimal number of indexes in the following scenarios:n1. When performance is critical, and frequent data modifications are expected.n2. For tables with fewer rows or small data sizes, where searching can be performed efficiently without indexes.n3. If you suspect that an index might lead to reduced performance due to the way it's designed or used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What is cursors? And what are the different types of cursor?
What is the difference between stored procedure and functions?
What’s the distinction between dropping a info and taking a info offline?
What is the SQL?????????????????????????????
How are the unique and primary key constraints different?
What extended events?
What is correlated subquery in sql server?
What is the difference between drop table and truncate table?
What is query cost in sql server?
What command is used to rename the database?
What are the types of sql server?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
