AW: Load a subfile with clients selected by user

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

I wonder if that static SQL would not be able to use the index though? 
Just curious

The query optimizer analyzes the SQL statement in either way and rewrite it.
The query optimizer is clever enough to determine if a field value is
specified or a complete range.
In this way the optimizer may use any index that is available.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von rob@xxxxxxxxx
Gesendet: Tuesday, 30. June 2009 19:14
An: RPG programming on the IBM i / System i
Betreff: RE: Load a subfile with clients selected by user

I wonder if that static SQL would not be able to use the index though? 
Just curious.

Rob Berendt