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
How to connect to db2 database from windows command line?
Define declaration generator (dclgen).
Where do you specify them?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is a Foreign Key?
Is db2 a programming language?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the result of open cursor statement?
How to execute stored procedures?
How to find the maximum value in a column in the db2 database?
List out the buffer pools in db2
What is the maximum number of columns in a db2 table?
What r the comman abends in db2, jcl and cobol???????
What are concurrency issues?
What are the benefits of using the db2 database?
