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 explain plan in db2?
Is ibm db2 free?
How can deadlocks be resolved?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a db2 table?
Define data page.
What is ibm db2 database?
Explain the benefits you can get from mainframe connect?
What is the syntax for FETCH in DB2 ?
What is collection in db2 bind?
What is sqlca?
What is innodb buffer pool?
What do you mean by rollback?
What is copy pending and check pending in db2?
What is the maximum length of sqlca?