explain about index with examples

Answer Posted / dilon

index are nothing but primary key in the table...
ex:create table emp(eno numeric(4) not null primary key,
ename char(10) not null,
elocation char(10) not null)
in this example employee number eno is the primary key it is
called as index...

Is This Answer Correct ?    1 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 look?

775


What is reorg?

827


What is meant by dclgen?

841


What parameters are used to control the free space in DB2?

827


How is a typical db2 batch pgm executed?

847


How to find the number of rows in db2 tables?

790


What are types of indexes?

761


What is buffer pool in the db2 database?

840


Is db2 a mainframe?

777


How to access db2 tables in mainframe?

790


What is bind in db2?

784


What are the contents of a dclmgen?

824


How to view db2 table structure?

784


what is the responsibility of the construction superintendent

1868


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

965