Which DB2 command is used to create an index on a table?
- CREATE INDEX
- ADD INDEX
- MAKE INDEX
- BUILD INDEX
The CREATE INDEX command is used to create an index on a table in DB2. It allows you to specify the columns to be indexed and various options such as unique constraints and index type. This command is essential for optimizing query performance by providing quick access to data based on the indexed columns.
Loading...
Related Quiz
- What is the primary goal of performance tuning in DB2?
- What is the primary purpose of the LOAD utility in DB2?
- How can you verify the successful completion of the DB2 installation process?
- The CLOB data type in DB2 is used for storing ________.
- Scenario: A DBA is optimizing the performance of a DB2 application that frequently processes large result sets. How can the use of cursors be optimized in this scenario?