Answer Posted / mani
After creating index by using CREATE command
CREATE UNIQUE INDEX IDX_EMP ON EMPLOYEE(EMP_ID)
To retreive index:
SELECT INDEX_NAME FROM USER_INDEX WHERE TBNAME='EMPLOYEE'
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is rct?
Mention the different locking levels that are available in db2.
How do I delete a column in db2?
What is load utility in db2?
What is clone table?
What is the reason behind not using select * in embedded sql programs?
What is the difference between plan and package in db2?
What is a db2 schema?
Is db2 a mainframe database?
List out the buffer pools in db2
What is table space in db2?
What is concurrency?
What is null in db2?
What r the comman abends in db2, jcl and cobol???????
What is alias in db2?