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 a dbrm in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What are the rules for db2 programming?
What are the contents of dclgen?
How will you return the number of records in table?
Explain the contention situations caused by locks?
How can you do the explain of a dynamic sql statement?
How to view db2 table structure?
What is db2 optimizer?
Outputs of explain are with matchcols = 0. What does this signify?
What are concurrency issues?
What is schema in db2?
What is cloudant database?
What is plan in cobol db2?
How to find the maximum value in a column in the db2 database?