Re: Select Query hangs up on IDS 9.40.

vpatel66@gmail.com wrote: > Michael Krzepkowski wrote: > >>vpatel66@gmail.com wrote: >> >>>We recently copied data from IDS 7.x to IDS 9.40 and we discovered >>>following SQL statements does not return any data even after couple of >>>hours on IDS 9.4, but it was running fine on IDS 7.x, >>> <SNIP> > I don't understand when it uses the index on ord_l table the query > hangs up and when it does sequential scan on ord_l table it returns > data within 5 minutes. Which definitely points to a data distribution problem. Just that fact that the cost of the selected query plan is an order of magnitude higher than the ones produced changing something is a clue. Are you certain that the stats were recalculated AFTER the copy to 9.40? How were stats produced? What release of 9.40? Art S. Kagel