Re: stats and query plans

2003-08-14 Thread Mark Richard
Subject: stats and query plans [EMAIL PROTECTED]

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
0, 2003 10:54 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, wi