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. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *