What is indexing, and how does it improve performance?
Indexing creates a data structure that speeds up data retrieval operations. It reduces the number of disk accesses required for queries. However, too many indexes can slow down INSERT, UPDATE, and DELETE operations.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between Sleep and Wait? (Java)
What are the uses of Database Trigger ?
How to add another datafile to a tablespace?
Why cursor variables are easier to use than cursors?
What is open database communication (odbc) in oracle?
What is user managed backup in Oracle?
What do database buffers contain?
What is meant by a deadlock situation?
What is merge statement used for?
What is archive log in Oracle?
Explain the use of online redo log files in oracle.
How to create a new user account in oracle?