RE: Query optimizer tells me to build an access path that already exists

Thanks
Vern

That's right.  It was a surprise to me when IBM told me this little tidbit.
We have an application that was giving between 3 to 6 minute response time
after we went to V5R2.  It always had poor response but not that bad.  I
called Tech Support at IBM and was told to create an index over the file.  I
said I had an index and that is what the SQL used in it's select,  They said
no, create an SQL index.  I forget the statistic but it has to do with the
amount of data SQL will fetch when using an SQL index vs. the access path of
a logical file.  I ran the application under debug, reviewed the optimizers
suggestions and created every index suggested.  The application now gives 1
second or better response.  My problem is how to predict what index SQL will
want to use.
Bill Erhardt