how can you access index

Answer Posted / raghu

first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What db2 400?

795


Define predicate?

749


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1723


How do I add a column to a table in db2?

713


What are bind parameters in db2?

691






What is the use of reorg in db2?

698


What is meant by explain?

742


How can deadlocks be resolved?

626


What is reorg?

694


What happens in bind step in a db2 program?

649


What is concurrency?

799


Mention the downsides of page level lock.

813


What is blu acceleration in db2?

697


What is the result of open cursor statement?

716


What is the reason behind not using select * in embedded sql programs?

706