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 deadlock in db2?

677


How can we retrieve the total number of records in RPG & CLLE?

276


What are host variables in db2?

708


List some fields from sqlca?

682


Describe major components of db2?

742






Mention some fields that are a part of sqlca.

680


What are the different types of base tables?

658


What is data manager?

695


Outputs of explain are with matchcols = 0. What does this signify?

709


Can there be more than one cursor open for any program?

773


How do I add a column to a table in db2?

713


What is page size in db2?

638


What are the 2 sqlcodes that are returned?

731


what is db2 restart?

1779


How do I delete a table in db2?

732