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 collection in db2 bind?

577


What is nvl in db2?

626


Comment whether the cursor is closed during commit or not.

674


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

1709


What is table space in db2?

582






How and when does the db2 enforces the unique key?

615


How would the varchar column remarks defined?

635


What is buffer pool and list some of them?

630


How can you count the number of rows from a table tab?

637


What is with ur in db2?

759


B37 abend during spufi?

981


What is temporal table in db2?

603


What is a page in db2?

610


What is the difference between using bind () and rebind () methods of naming class?

792


Which component is responsible for db2 startup and shutdown?

630