Answer Posted / ashok kumar
we generally use the folling query for create index
CREAT INDEX <index name> on <table name>(cols1,cols2,...)
for accessing columes :
SELECT ENAME FROM EMP
WHERE cols1 and cols2
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is collection in db2 bind?
Why do we need reorg in db2?
What does db2 plan contain?
What is meant by union and union all?
What is db2 connect?
What is ibm db2 database?
What is node in db2?
What are foreign keys in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is nvl in db2?
What is ibm db2 used for?
Which isolation level provides highest data integrity?
Mention the downsides of page level lock.
What is a cursor in programming?
What is the syntax for creating a table in the db2 database?