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
What is meant by union and union all?
What are packages in db2?
What does runstats do in db2?
What is a system catalog table in db2?
Which isolation level provides highest data integrity?
what is the responsibility of the construction superintendent
What is null indicator in cobol db2?
How do I create a view in db2?
How do I change the column size in db2?
Explain about dbrm.
What is the difference between cursor stability and repeatable read isolation levels?
What is the use of predicate?
On which levels locks can be applied?
What is runstats db2?
What is drop table?