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

How many databases are there?

596


What is a trigger in the db2 database?

602


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

727


Is it possible to create an Instance in DB2 using DB2 Control Center ?

635


What does db2 mean?

591






What is host variable in db2 cobol?

616


What is db2 bind?

644


What is the latest version of ibm db2?

748


Explain db2.

628


What is a system catalog table in db2?

594


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

710


How to execute stored procedures?

626


What is database alias db2?

619


What are the bind parameters ibm db2?

628


What is temporal table in db2?

609