Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004

    Unanswered: Tables and indexes in diferent dbspaces

    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.

  2. #2
    Join Date
    Aug 2004

    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

  3. #3
    Join Date
    Mar 2004
    You will get even better performance if the disks are on separate channels.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts