Re: Informix Optimiser: Should I use it?

> On Mar 7, 9:34pm, Peter Wotherspoon wrote: > Subject: Informix Optimiser: Should I use it? > This may seem like a strange question, but our software supplier > has told us that we must on no account update the database > statistics, as it will (a) make queries run more slowly, and > (b) make the rows return in the wrong order - they rely upon > the implied order of rows returned by their chosen index rather than > using "order by". > [stuff deleted] >-- End of excerpt from Peter Wotherspoon Peter, My advice is "heed your software supplier's advice". Ignore any other well meant but ill informed words of wisdom. Hope This Helps, -- Tom Hogarty <STANDARD DISCLAIMERS APPLY> Performance Analyst Pyramid Technology Corp (A Siemens Nixdorf Company) San Jose CA95164