how can you access index

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


Please Help Members By Posting Answers For Below Questions

What is explain plan in db2?

786


Is ibm db2 free?

776


How can deadlocks be resolved?

741


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

830


What is a db2 table?

778


Define data page.

834


What is ibm db2 database?

737


Explain the benefits you can get from mainframe connect?

739


What is the syntax for FETCH in DB2 ?

936


What is collection in db2 bind?

781


What is sqlca?

823


What is innodb buffer pool?

761


What do you mean by rollback?

761


What is copy pending and check pending in db2?

761


What is the maximum length of sqlca?

1146