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 do you mean by between and in? Is between inclusive of specified range values?

1088


Mention the various locks that are available in db2.

1031


How do I connect my db2 database to ibm?

1042


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2382


How to find the number of rows in a db2 table?

1114


How do I start db2 in windows?

1086


Define check constraint.

1068


What is the role of schema in the db2 database?

1263


What is explain plan in db2?

981


What's The Error Code For Unique Index Voilation?

1224


How is a typical db2 batch pgm executed?

1169


How do I add a column to a table in db2?

1098


What is reorg and runstats in db2?

1213


What is db2 bind process?

1233


When do you specify the isolation level?

1024