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 ibm db2 used for?
How to find the number of rows in a db2 table?
What type of database is db2?
Highlight all the advantages that are attached to a package.
What is dclgen in db2?
What is page size in db2?
How can deadlocks be resolved?
What is the maximum number of columns in a db2 table?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the use of commit in db2?
What is the use of runstats in db2?
Explain package in db2 and its advantages?
Where can you declare a cursor in a cobol-db2 program?
What are types of indexes?
What language is db2 written in?
