RE: SQL keys

Hi Donna,

Are you thinking of index (logical files) when you talk about SQL keys?


Yours sincerely / Med venlig hilsen

Esben Kiel Sørensen
Software Developer
XA CC - System Architecture
Group IT

Vestas Wind Systems A/S
Tel.: +45 9730 7126
Mob.: +45 2546 3906
E-mail: eksor@xxxxxxxxxx




-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of donna lester
Sent: 12. marts 2008 23:38
To: RPG programming on the AS400 / iSeries
Subject: SQL keys

Hi
I heard the performance of the programs improve with new SQL keys.The performance I meant is whether the programs run faster with new SQL keys.

I would like to find out merits&demerits of having SQL keys from anyone who has experience using them.

I thank you all who responded on my MQ question, your information was very helpful.





Thanks,

Donna.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.