Interested to Buy Any Domain ? << Click Here >> for more details...
explain about index with examples
- 2 Answers
- 6819 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 |
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is buffer pool?
What is db2 instance?
What is cursor in dbms?
How can you do the explain of a dynamic sql statement?
Is db2 a mainframe database?
what is a plan and how do you refer the plan in the program?
What is plan in cobol db2?
how to resolve -805. give clear explination for that
What is the use of reorg in db2?
What is meant by AUTO COMMIT?
What is cloudant database?
COBOL 
