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 |
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What is ibm db2 connect?
What is a NULL value? What are the pros and cons of using NULLS?
What is the connection string to connect to the DB2 Database ?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How do I connect my db2 database to ibm?
Can we declare DB2 HOST variable in COBOL COPY book?
what types of copies can be made with the COPY Utility ?
What is reorg in database?
How to retrieve rows from a db2 table in embedded sql?
What is EXPLAIN?
What are PACKAGES ?