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
What is db2 look?
What is reorg?
What is meant by dclgen?
What parameters are used to control the free space in DB2?
How is a typical db2 batch pgm executed?
How to find the number of rows in db2 tables?
What are types of indexes?
What is buffer pool in the db2 database?
Is db2 a mainframe?
How to access db2 tables in mainframe?
What is bind in db2?
What are the contents of a dclmgen?
How to view db2 table structure?
what is the responsibility of the construction superintendent
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