Use/Dont Use ROWID in queries
From: <zahgurim_at_ix.netcom.com>
Date: 1995/12/21
Message-ID: <1995Dec21.121807.7261_at_inet.d48.lilly.com>#1/1
Date: 1995/12/21
Message-ID: <1995Dec21.121807.7261_at_inet.d48.lilly.com>#1/1
Readers:
I was told recently that ROWID should not be used in queries since it is not unique, especially if the tables are clustered [whatever that means] and you loose the rowid when you do an export/import of the data.
I am conufused on this matter and was wondering if anyone could help clarify this for me. I always heard that you should use ROWID whenever it is possible since it's the fastest way to manipulate records and other reasons.
Thanks for you time in advance!
Happy Holidays Received on Thu Dec 21 1995 - 00:00:00 CET