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 bind plan?

796


How to find schema of a table in db2?

740


What type of database is db2?

707


What is the difference between bind and rebind in db2?

1169


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

927


What is meant by dclgen?

841


How can you quickly find out the # of rows updated after an update statement?

788


What is the maximum number of columns in a db2 table?

976


What is universal database?

822


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2647


Why do we use cursor?

786


How do I delete a table in database?

775


Before you give the explain statement, what are the prerogatives?

761


Can we delete records from view?

742


Explain dclgen.

925