Re: ODP / SQL Question.

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

Create an index not a dds logical file.

This doesn't mean the query optimizer will pick it. 
It may take a little work (in defining the index) to
get the query optimizer to use the index.

Phil


--- "Hatzenbeler, Tim" <thatzenbeler@clinitech.net>
wrote:
>       We have a purchased piece of software, that works
> pretty good, but
> there is one program that seems to suck up our
> resources.
> 
>       So I looked at it, and it happens to be a RPGSQL
> function, and it
> does a lot of interactive indexing.  So my questions
> is this.  Can I created
> a logical file similar to this SQL, and index it the
> same.  So when this sql
> is activated it would be smart enough to use an
> already created index
> instead of creating one from scratch on the fly? 
> And if so, is there
> anything special I need to do to attach the logical
> to the job?
> 
>       Thanks, tim
> 


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---