From deepakthapliyal@yahoo.com Fri, 19 Oct 2001 10:11:34 -0700 From: Deepak Thapliyal Date: Fri, 19 Oct 2001 10:11:34 -0700 Subject: Re: Separate tablespaces for indexes on same table? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi cherie, In an ideal world i would like to use separate tablespaces for indexes. however first check what lun configuration was used to design your mount points. might not buy you much if you have a set of index tablespaces under same mount point in terms of performance at least. might also not buy you much if you have a set of index tablespaces under differnet mount point (assuming lousy lun configuration) but under both above worst cases .. it atleast avoids some maintainance haggles .. so to cut to the chase .. diff indexes on diff tblspcs makes sense makes even more sense to also have a tete-tete with the sysadmin and understand your how many mount points you have and how they have been configured. I generally go by the 101 perf book by gaja and kirti which uses the principle of having 3 categories(tablespaces) like small/medium/large or something like that. so once you have these tablespace, just start dumping the indexes in them based on the sizes of the indexes. hth deepak --- Cherie_Machler@gelco.com wrote: > > I am rebuilding some indexes for a 20-Gig table. I > am following the > recommendations in the paper How to Stop > Defragmenting and Start Living... > > There are six indexes on this table. According to > the paper, I should > create a separate tablespace for these indexes. My > question is: Should I > put all of the indexes in a single tablespace or > should I make two > tablespaces and separate them. In some queries, > the indexes may be used > together but in most they will not. If I put them > in a single tablespace, > will that cause I/O contention. > > This is on 8.0.4 Sun E10K Solaris 2.6 with Veritas > Quick I/O. > > Thanks, > > Cherie Machler > Gelco Information Network > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: Cherie_Machler@gelco.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@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). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: deepakthapliyal@yahoo.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@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).