explain about index with examples
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 use of commit ? and what is the syntax?
what is Static and dynamic linking
What is meant by concurrency?
Could anyone clearly explain the diference between sub query and correlated sub query?
What does reorg do in db2?
what is the name of the default db2 catalog database?
How to resolve -805 error in DB2?
What is a clustering index ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
List down the data types in the db2 database.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the connection string to connect to the DB2 Database ?