Re: Detached Indexes (Baan/Informix)

Assuming it is mostly OLTP and not a gigantic system (>500+ GB, 1000+ concurrent users minimum), I doubt it matters much. You'll mostly sink or swim with your buffer hit ratio. If you do lots of heavy reporting queries, you might be better off as is. I wouldn't mess with it without a pretty good reason. Greg Fergus Hayne wrote: > > Hi, > > I recently posted a message querying my Baan and Informix set up. One of > the replies suggested that I should avoid having detached indexes. However > all of the indexes on the systems I have taken over are detached and are on > a separate dbspace. > > Is this a problem? If so why? Should I be thinking about re-attaching my > indexes? > > Thanks in Advance > > -- > Fergus Hayne > HP-UX / Informix / Baan Administrator > Brand-Rex Limited > EMail: fhayne@brand-rex.com