Re: Problems converting from Informix SE to Online...

In article <3hbn33$llj@newsbf02.news.aol.com>, mcmark6199@aol.com (McMark6199) says: > ... >but we have one problem. We have an Access >query that ran fine against the SCO but when you run it against the same >database on the HP it creates a HUGE temp file on the PC (500 meg before >it brought down the server!). ... If you create the same indexes on the SCO box as on the HP, does it also create the nasty temp files? Have you examined the query with 'SET EXPLAIN' to see why they are created? Informix can be very easily confused when it has too many indexes to 'think' about. Also altering the optimisation level (from high to low) may help. Hope this helps. Sally.