Interested to Buy Any Domain ? << Click Here >> for more details...
explain about index with examples
- 2 Answers
- 6921 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapnil
USING AN INDEX WE CAN ACCESS THE KEY VERY FAST
ON PRIMARY KEY YOU CREATE AN INDEX.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
How do you retrieve the data from a nullable column?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is ibm db2 connect?
What is iseries database?
What is a DBRM, PLAN ?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is a DB2 access path?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
How many buffer pools are available in db2?
What is the SQL Communications Area and what are some of its key fields?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What are the different types of base tables?
COBOL 
