Answer Posted / pandu
first of all create index
create index<indexname> on <tablename>(<columnname>);
after that we have to access to that by
Select * from <indexname>
Correct me is am i wrong...
Thank You.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Why do we bind in db2?
What is dbrm library?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What do you mean by storage group (stogroup)?
What is the advantage in De-normalizing tables in DB2?
what is db2 restart?
Is db2 relational database?
Mention some fields that are a part of sqlca.
What is the use of dclgen in db2?
How to find primary key of a table in db2?
What is null value in db2?
What does db2 blu stand for?
Explain package in db2 and its advantages?
What is buffer pool in the db2 database?
How do you simulate the explain of an embedded sql statement in spufi/qmf?