To fragment or not to fragment - opinion

Whatever you choose to do, be aware that when fragmenting the optimiser will need to search all fragments (or all index fragments) when processing your query. In fact in INFORMIX-OnLine 7.10.UD1 even if your table is not fragmented but it's index is in another dbspace, when you do an OPEN on a cursor all selectable rows are retrieved into a temporary table. This happens even if the index could be used to identify the selected rows. Refer problem no 40006 to be resolved in 7.20. So, I respectfully suggest, if you decide to fragment, use SET EXPLAIN to check that the optimiser is getting confused. -- Regards, Chris ------------------------------------------------------------------------------ Chris Wegener Mincom Pty Ltd, Database Consultant Wyandra Street, | | | | | | chrispw@tenmail.mincom.oz.au Teneriffe, Brisbane, | | | | | | Phone: +61 7 3303 3333 X2288 Queensland, | | | | | | Fax: +61 7 3303 3232 Australia 4005 |M |I |N |C |O |M ------------------------------------------------------------------------------