Is there a benefit in having indexing on separate spindles

Posted in 1996

Peter Tashkoff — 22 Oct 1996 23:43:06 -0400 — source: Informix-list mailing list archive (1991-1998)

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.