Hi,

I have a table with 25 columns and 6 columns are defined as primary key and unique rule is 'P'

As per my requirement , I am using one of the primary key coulmns in where condition of my select SQL.

Do I need to use all the primary key columns in where condition to activate my composit index ? or Will the composit index is activated if I use single column ?

If I have to use all the coulmns then what is the syntax to use all the columns ?


My table indexes are below

Index Index Unique Number of
schema name rule columns
-------------- ------------------ -------------- -------------------------------------------------------
DMSC XIF1CSA_CALL_AUX_F D 1
DMSC XIF2CSA_CALL_AUX_F D 1
DMSC XIF6CSA_CALL_AUX_F D 1
DMSC XIF7CSA_CALL_AUX_F D 1
DMSC XPKCSA_CALL_AUX_FA P 6
DMSC CALL_AUX_FACT_IDX D 1
DMSC CALL_AUX_FACT_IDX1 D 3



The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

DB2 & UDB email list listserv db2-l LazyDBA home page