Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Q: index only table for single unique field?

Q: index only table for single unique field?

From: <tedchyn_at_yahoo.com>
Date: Tue, 07 Sep 1999 18:36:57 GMT
Message-ID: <7r3m07$u19$1@nnrp1.deja.com> 





Sir, what is pro and cons for index only table in terms of performance ?
I have a master credit card number which is unique by itself. Two
alternatives are here:


1. regular table with card_number field and unique index on card number
and


2. index only table with card)number field.



Any suggestion is greatly appreciated.


Ted chyn(tedchyn_at_yahoo.com)




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Tue Sep 07 1999 - 13:36:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US