Ben Chobot wrote: > Here is the plan on 8.4.2: > Here is the very much less compact plan for the same query on> 8.1.19: Could you show the query, along with table definitions (includingindexes)? -Kevin