how can you access index

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


Please Help Members By Posting Answers For Below Questions

How to execute stored procedure in db2 command editor?

630


What is cursor in dbms?

701


what is db2 restart?

1779


What do you mean by commit and rollback?

680


What is ibm db2 connect?

652






What is bind plan?

702


Explain package in db2 and its advantages?

699


How to access db2 tables in mainframe?

696


What is the role of data manager in the db2 database?

727


What is meant by union and union all?

670


What is explain plan in db2?

674


What is commit in db2?

687


How to find schema of a table in db2?

658


What is the syntax for seeing the columns and data types of a table in the db2 database?

659


What is host variable in db2 cobol?

707