In an Informix database, the tables are in different dbspace & indexes are in different dbspace

Would this effect the query performance.

Please throw some light on this.

Hi,

it is totally recommended to put data and indexes in different dbspaces that point to different storage devices. Not only the query performance is better, but also any inserts, updates and deletes since you have two or more disks working in parallel.

Hope this helps

You will get even better performance if the disks are on separate channels.