Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: Q: To check a record's existence in a table, FAST!
Re: Q: To check a record's existence in a table, FAST!
Two thoughts:
- Clearly an index on ColA is required.
- Hashing makes this kind of thing very fast for the right type of
data. Consider putting the table in a cluster along with the
appropriate index.
John..
Received on Sat Apr 19 1997 - 00:00:00 CDT
Original text of this message