Db2 datbase access using primary key+non indexed key - Performance issue?

Question

Hi,

Our DB2 database tables have a composite primary key containing two columns. All stored procedures associated with the database are working with access keys same as primary key.

Will there be a perfomance impact if we change the stored procedures to query the tables using Primary key+ one non indexed colum?

Thanks in advance!
Arun.

Answer 1

Not really. If the primary key is enough to limit the results to say 100 or so, then the additional criteria won't affect the performance.

Answer 2

Should be the same, if not faster than if you just used the primary key.