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 can you classify the locks in db2?
How does the processing of a correlated subquery differ from a non correlated subquery?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is runstats utility in db2?
Return code 100 means?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
Can we update view in db2?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is table space in db2?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert