English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

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.

2006-07-19 08:05:23 · 2 answers · asked by camry96 2 in Computers & Internet Programming & Design

2 answers

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.

2006-07-19 08:11:46 · answer #1 · answered by Todd V 3 · 0 0

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

2006-07-19 15:16:49 · answer #2 · answered by ztc 1 · 0 0

fedest.com, questions and answers