Hi Sam
What happens when you analyse tables?
Can you give me some example of how to use a CBO hint in a query.