Interested to Buy Any Domain ? << Click Here >> for more details...
explain about index with examples
- 2 Answers
- 6961 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 |
What is the meaning of -805 SQL return code?
What is the use of db2 optimizer?
What are the disadvantages of PAGE level lock?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How to define the a field which accepts value till 99999.99 in db2
How to create db2 table in mainframe?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
Why select is not preferred in embedded sql programs?
What is difference between rollback and commit?
What are the contents of a dclmgen?
How do you Load a table ?? and what is Load replace ?
What is the purpose of the DSNC transaction ?
COBOL 
