RE: Index Constraint

2002-06-10 Thread Sherman, Paul R.
-Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] 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

RE: Index Constraint

2002-06-09 Thread Igor Neyman
Hamid, First, I don't think it's high class to misspell my name intentionally (you did it more than once). Second, rtfm is best advice, you can get, when asking such generic questions, which show your unwillingness to do your home work and which could (and should) be investigated first using

RE: Index Constraint

2002-06-09 Thread JoJo Al-Zawawi
Come on, you guys. If you don't want to answer somebody's question, all you have to do is Delete the e-mail. You really don't have to respond rudely. You don't even have to say rtfm. You could NICELY point out, your best bet is the manual. You know what? Sometimes for us newbies, the

Re: Index Constraint

2002-06-08 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: An example on my understanding of Reverse Key Indices: Say you have a table EMP with a column EMPNO, and an index on this field.This number is incremented sequentially for every new employee that joins in. And as employees retire, say, the records are deleted.

RE: Index Constraint

2002-06-07 Thread Jamadagni, Rajendra
No, don't use reverse index for FKs, on certain versions they caused havoc by allowing parent key to be deleted (Metastink has an alert on this one). Reverse indexes are preferred in OPS environment AFAIK. Raj __ Rajendra Jamadagni

Re: Index Constraint

2002-06-07 Thread Igor Neyman
rtfm Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
What about PK, which one should be, normal or Reverse, I can see in one of my database, Erwin generate all PK as normal/reverse ? -Original Message- Sent: Friday, June 07, 2002 1:33 PM To: Multiple recipients of list ORACLE-L No, don't use reverse index for FKs, on certain versions

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
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 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

RE: Index Constraint

2002-06-07 Thread Rajesh . Rao
: @espn.com Subject: RE: Index Constraint Sent by: [EMAIL PROTECTED

Re: Index Constraint

2002-06-07 Thread Igor Neyman
Hamid, Which part of RTFM you didn't understand? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:28 PM Igore, rtfm is a very complex answer, please reply clearly!! -Original

RE: Index Constraint

2002-06-07 Thread Rachel Carmichael
read the fine manual you might, by doing a bit of research, get the answers on your own. It's definitely a way to learn more --- Hamid Alavi [EMAIL PROTECTED] wrote: Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07, 2002 1:18

RE: Index Constraint

2002-06-07 Thread Gogala, Mladen
Read The Frigging Manual -Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] 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

RE: Index Constraint

2002-06-07 Thread JoJo Al-Zawawi
Running To Find Mama. Just kidding around, JoJo -Original Message- Sent: Friday, June 07, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07, 2002 1:18 PM To: Multiple

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
Igore, The RTFM part ! -Original Message- Sent: Friday, June 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Hamid, Which part of RTFM you didn't understand? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
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 [EMAIL PROTECTED

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
Igore, I didn't expect even in this group you can find such low class people If you want to use these sort of words please keep it for yourself. -Original Message- Sent: Friday, June 07, 2002 1:18 PM To: Multiple recipients of list ORACLE-L rtfm Igor Neyman, OCP DBA [EMAIL

RE: Index Constraint

2002-06-07 Thread Rachel Carmichael
rtfm can be read as read the fine manual exactly what sort of language are you accusing Igor (and it would be nice if you managed to spell his name correctly) of using? you have spent a good deal of time asking people on this list for help for things that you could easily find in the manuals, if