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 are the 2 sqlcodes that are returned?

907


What is the difference between bind and rebind in db2?

1224


What is node in db2?

839


Is db2 a programming language?

827


How do I connect my db2 database to ibm?

826


What is copy pending status in db2?

897


What is dbrm?

887


What is db2 bind?

843


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1950


How does a cursor work?

784


How to create backup table in db2?

881


How is deadlock resolved?

872


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2044


How can you do the explain of a dynamic sql statement?

863


Explain the contents that are a part of dclgen.

905