| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
as I said, 26 CPUs, 9GB RAM, lots of disks......
oh, and they wanted a bitmapped index on that table too
somedays it don't pay to get out of bed
>From: Henry Poras <Henry.Poras_at_ctp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
>Date: Mon, 11 Jun 2001 12:41:32 -0800
>
>Let's see. What was that rule of thumb I heard from Kevin Loney? I think it
>was that each index slows down DML by a factor of 3 (at least for batch
>jobs
>where you have to worry about recursive SQL). So 23 indexes would run about
>70 times slower than no indexes. Do I sense a hardware throwing contest??
>
>Henry
>
>-----Original Message-----
>Sent: Monday, June 11, 2001 4:01 PM
>To: Multiple recipients of list ORACLE-L
>
>
>On Monday 11 June 2001 09:06, Rachel Carmichael wrote:
> > OLTP system, main order table had 23 indexes on it. Because they wanted
>to
>
>?!?!?!
>
>That's just nuts.
>
> > be able to search by customer first name, customer last name, recipient
> > first name, recipient last name .... and had foreign keys all over the
> > place.
>
>Sounds like Data Mart was a term they were unfamiliar with.
>
>Jared
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> INET: jkstill_at_cybcon.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: Henry Poras
> INET: Henry.Poras_at_ctp.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: Rachel Carmichael INET: carmichr_at_hotmail.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).Received on Mon Jun 11 2001 - 16:05:39 CDT
 |
 |