Interested to Buy Any Domain ? << Click Here >> for more details...
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
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the use of dclgen in db2?
Explain what are the various isolation levels possible?
What is the difference between cursor stability and repeatable read isolation levels?
Why cursor is used in db2?
What is db2 optimizer?
What are packages in db2?
What is ibm db2 client?
How will you return the number of records in table?
What is the advantage in De-normalizing tables in DB2?
What is cursor stability in db2?
What is the picture clause of null indicator variable?
What are the uses of db2 optimizer?
What is db2 connect?
List out the data types available.
