Re: RE: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread rgaffuri
does anyoen disagree? Didnt this get started with the 'DBA Handbook' or was it a different text? From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 11:10:05 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: should you seperate indexes from

Re: RE: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread rgaffuri
access to data, then build the indexes while the instance is online? From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 11:39:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: should you seperate indexes from tables in seperate datafiles I

Re: Re: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread rgaffuri
why is it useful to seperate different i/o pattersn? such as multi-block reads and single block reads? From: Nuno Souto [EMAIL PROTECTED] Date: 2003/07/15 Tue AM 11:59:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: should you seperate indexes from tables

RE: RE: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread Rachel Carmichael
PROTECTED] Subject: RE: should you seperate indexes from tables in seperate datafiles R, Some of it depends on the disk storage. I have always followed the time-proven method of organizing disks and placing indexes away from the tables they belong to. Our warehouse

RE: RE: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread Cary Millsap
PROTECTED] Subject: RE: should you seperate indexes from tables in seperate datafiles R, Some of it depends on the disk storage. I have always followed the time-proven method of organizing disks and placing indexes away from the tables they belong to. Our

RE: RE: should you seperate indexes from tables in seperate datafiles

2003-07-15 Thread Rachel Carmichael
indexes from tables in seperate datafiles R, Some of it depends on the disk storage. I have always followed the time-proven method of organizing disks and placing indexes away from the tables they belong to. Our warehouse is using EMC external disk