RE: DSPFD & dates

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Tested this today - if index is selected by the optimizer, the last used is 
updated. But not if it was used for cost estimation only, I believe. IMO, 
that would be good information, to prevent the situation you describe. 
I.e., use of the index to forestall building temporary indexes.

HTH

Vern

At 01:46 PM 6/18/2003 -0700, you wrote:
> Well, one thing I noticed is that running DSPFD will update the
> extract date/time(s) but not the last used :)  I know that
> running a program that uses the file will update the 'last used'
> but I don't know if SQL or OPNQRYF updates this if the logical
> is used as an index to perform a query.  I almost don't think
> they do but this could be tested easily enough.  I would be
> careful deleting logicals that you think aren't used because
> they may be avoiding building indexes on the fly in places.  I
> know this because someone here once was being helpful and
> cleaned up unused logicals, performance of some jobs/programs
> just became terrible.  So be careful :)
>
> Scott Mildenberger