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 |
Explain dclgen.
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is usage pointer in cobol?
Is db2 a mainframe database?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
can any one expalin check point with an example?
How do I start db2 in windows?
What is the difference between using bind () and rebind () methods of naming class?
Define predicate?
what is REORG? what is the use?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
How to know the primary key of a table without defining the primary key in the table?