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

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278


What is the syntax for seeing the columns and data types of a table in the db2 database?

1171


What are iseries servers?

1080


How do I delete a table in db2?

1083


Is db2 a database?

984


What is buffer pool?

1110


What is the picture clause of null indicator variable?

1138


What is the maximum size of a char data type in db2?

1012


What is table space in db2?

1025


What is the information associated with sysibm.syslinks table?

1129


Give a brief description of db2 isolation levels?

1076


When the like statement is used?

1227


What is a collection in db2?

1041


What is ibm db2 used for?

1086


What is bufferpool in db2?

1059