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
Mention the various locks that are available in db2.
Are views updateable?
How to find the number of rows in db2 tables?
What is an instance database?
What is the role of schema in the db2 database?
Is the primary key a clustered index?
What are union and union all?
How to check table size in db2 sap?
What is ibm db2 connect?
What is db2 bind process?
How can record locking be achieved in those DB2 versions which do not support it?
What are iseries servers?
How do you select a row using indexes in db2?
Describe major components of db2?
How can we retrieve the total number of records in RPG & CLLE?
