RE: Index & Constraint

Thanks ALL, Specialy Igore.....

-----Original Message-----
Sent: Friday, June 07, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L

Read The Frigging Manual

> -----Original Message-----
> From: Hamid Alavi [mailto:hamid.alavi_at_quovadx.com]
> Sent: Friday, June 07, 2002 5:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Index & Constraint
>
>
> Igore,
> rtfm is a very complex answer, please reply clearly!!
>
> -----Original Message-----
> Sent: Friday, June 07, 2002 1:18 PM
> To: Multiple recipients of list ORACLE-L
>
>
> rtfm
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, June 07, 2002 3:46 PM
>
>
> > Hi List,
> > What's the diffrent between unique constrint & unique
> index, when we have
> to
> > use which, I think both are the same.
> > Any Idea?
> > And what about normal index & reverse index? when we have
> to use normal
> and
> > when reverse index, I think Reverse index normaly using for
> FK index, Is
> it
> > right or not?
> > Thanks
> >
> >
> >
> >
> >
> > Hamid Alavi
> > Office 818 737-0526
> > Cell 818 402-1987
> >
> >
> >
> >
> >
> >
> > ======================= Confidentiality Statement
> =======================
> > The information contained in this message and any attachments is
> > intended only for the use of the individual or entity to which it is
> > addressed, and may contain information that is PRIVILEGED,
> CONFIDENTIAL
> > and exempt from disclosure under applicable law. If you
> have received
> > this message in error, you are prohibited from copying,
> distributing, or
> > using the information. Please contact the sender
> immediately by return
> > e-mail and delete the original message from your system.
> > ===================== End Confidentiality Statement
> =====================
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Hamid Alavi
> > INET: hamid.alavi_at_quovadx.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
> INET: ineyman_at_perceptron.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
> ======================= Confidentiality Statement
> =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED,
> CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have
> received
> this message in error, you are prohibited from copying,
> distributing, or
> using the information. Please contact the sender immediately
> by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement
> =====================
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





======================= Confidentiality Statement ======================= 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
===================== End Confidentiality Statement =====================  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: hamid.alavi_at_quovadx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).