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
Is db2 a database?
If I have a view which is a join of two or more tables, can this view be updateable?
What's The Percentage Free Space ?
What is a Foreign Key?
What is role in db2?
What is the role of data manager in the db2 database?
What are db2 tables?
can we view the access paths created by dbrm ? how ? thx
What is buffer pool in the db2 database?
How do I copy a table in db2?
Mention some fields that are a part of sqlca.
Who uses db2?
What are the two types of logging in the db2 database? Explain them.
Explain correlated sub-queries.
Which is faster delete or truncate?