Re: Is there a benefit in having indexing on separate spindles

Peter Tashkoff wrote: > > from Data. > > Hi > I am been speaking recently with an > Oracle DBA (Tired looking fellow). > He mentioned to me that he always made > a practice of storing table indexes on > separate spindles from table data, and > that this provided performance > benefits. > I would be interested in hearing from > anyone who is doing this in informix > and is experiencing performance gains. > Or even peoples opinions on the > subject. > TIA. > -- > -- > Peter Tashkoff <tashkop@kiwi.co.nz> > NZ Kiwifruit Marketing Board Usual > disclaimers apply. > This posting may not be used by any > party to vilify another. Hi Peter ! I think the Oracle guy is right. The advantage is that index data and table data can be read concurrently. I have made this experience with Oracle, too. But I think it is also true for Informix. This opinion is supported by a Informix tech consultant, who told me that it is a good idea to create a seperate index dbspace and put it on a different disk. In real life it works fine so far ! Tschuess, tired looking Dirk ;-) -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------