Just a quick note on indexes... and kind of goes to the EMC question.
The location of the index is stored in header of the file itself! This can
lead to a problem if you have a copy of the data somewhere else
and try to use it. For example, we'll occasionally want to see how a
file/record looked from a few days ago. We'll restore it to
an alternate path. The first thing you MUST DO before you touch that file is
SET.INDEX (filename) TO NULL -- If you don't and you
start accessing it (iirc, even a read can make it go check the indexes) it will
start updating the live file's index with the restored files
data. Best part if you may not even know, until things (like SELECTs just
don't work in your production account.
Robert
Robert F. Porter, MCSE, CCNA, ZCE
Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
(504) 842 - 5185
This transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the
solicitor-client or other applicable privileges), or constitute non-public
information. Any use of this information by anyone other than the intended
recipient is prohibited. If you have received this transmission in error,
please immediately reply to the sender and delete this information from your
system. Use, dissemination, distribution, or reproduction of this transmission
by unintended recipients is not authorized and may be unlawful.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
