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. Oracle does teach that the indexes should be seperated. I have done this with Informix and did not experience any significant performance gain. What I did experience is that it uses more disk space and the backups take longer and use more tape. Also there seems to be a bug in Informix when you seperate indexes that the some indexes will get corrupt. This happened in Informix 7.12 and once we put the indexes back with the tables the problem went away. I have monitored activity on my disks and have not seen any performance problems with the indexes seperated or together. What I do do is seperate high activity tables onto other drives to distribute the I/O more evenly. Now this does help performance and prevents I/O bottlenecks. Keith