Also, as my new LF is only currently used in my SQL request, there are no
references it. How should I prevent someone from cleaning up and removing
So, what you are saying is that someone runs a Hawkeye or Pathfinder like
tool and see's no references to a file and then, based on that, deletes
it? So if I copy the item master (let's call it IIM) to a special copy
like IIM2008 and I have no "HLL" programs that refer to that then others
feel it is fair game to delete?
I have a table called BISMUTH. I have an index built over one field
(MYKEY) called BISMUTHA. Last used date on the member was 9/11/08. I do
select mykey from bismuth order by mykey
and the last used date on the index BISMUTHA is updated to today. Notice,
I didn't specify to use that index - sql just knew to do so.
I am running a little short on time to go looking through all the sql
statistics files to see if there's some info there.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact