explain about index with examples

Answer Posted / swapnil

USING AN INDEX WE CAN ACCESS THE KEY VERY FAST
ON PRIMARY KEY YOU CREATE AN INDEX.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is universal database?

617


How does cobol compile db2 program?

608


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1236


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


What is a db2 tablespace?

602






What is buffer pool?

613


How do I optimize a query in db2?

622


What is ibm db2 database?

538


What is dbrm? When it will be created?

598


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2322


Can we update view in db2?

561


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3120


Is ibm db2 free?

575


When reorg is used?

672


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

614