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 the use of runstats in db2?
What are the various data types available in db2?
How to connect to db2 database from windows command line?
Outputs of explain are with matchcols = 0. What does this signify?
What action db2 takes when a program aborts in the middle of a transaction?
What is isolation level in db2?
What is db2 purescale?
What is a buffer in memory?
what are bind concepts in db2 cobol?
Which is faster delete or truncate?
Explain the function of data manager.
List down the types of triggers in the db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the purpose of using commit?
How to access db2 tables in mainframe?