stats and query plans

2003-08-14 Thread Sai Selvaganesan
hi a very basic question i have faced this issue a few times in the last couple of weeks. we have a few queries that seem to run remarkable well in rule based optimisation than in choose based optimisation. the queries, with all the object stats collected upto date, never returns a result while

Re: stats and query plans

2003-08-14 Thread Tanel Poder
PM Subject: stats and query plans hi a very basic question i have faced this issue a few times in the last couple of weeks. we have a few queries that seem to run remarkable well in rule based optimisation than in choose based optimisation. the queries, with all the object

Re: stats and query plans

2003-08-14 Thread Mark Richard
and query plans [EMAIL PROTECTED] .com