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
What is db2 look?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the use of db2?
What does reorg do in db2?
What is explain plan in db2?
How do I add a column to a table in db2?
What is a page in db2?
How can we retrieve the total number of records in RPG & CLLE?
How many databases can be created inside an instance in db2 ?
Before you give the explain statement, what are the prerogatives?
How can record locking be achieved in those DB2 versions which do not support it?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the physical storage length of timestamp data type?
What is dbrm in db2 database?
How can you find out the # of rows updated after an update statement?
