Interested to Buy Any Domain ? << Click Here >> for more details...
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 drop table?
What are the contents of dclgen?
Why do chiropractors use drop table?
Can one database have multiple instances?
What is db2 plan table?
What is the use of runstats in db2?
How do I import a csv file into db2?
What is coalesce in db2?
What is bind plan?
Where can you declare a cursor in a cobol-db2 program?
How can you find out the # of rows updated after an update statement?
Before you give the explain statement, what are the prerogatives?
How many types of page locks can be held in db2?
Explain in detail about buffer manager and its functionalities?
What is consistency token in db2?
