Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 the use of runstats in db2?

1179


What are foreign keys in db2?

1170


What is dpf in db2?

1167


How can record locking be achieved in those DB2 versions which do not support it?

1130


How can we read records for specific member in CL? AND rpg?

758


How many types of page locks can be held in db2?

1090


What is buffer pool in the db2 database?

1157


What is a collection in db2?

1093


How to access db2 tables in mainframe?

1103


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2774


What are catalog tables in db2?

1106


How to find the number of rows in db2 tables?

1129


How do you stop a db2 database in linux?

1059


What is iseries database?

1118


How does a cursor work?

1041