QUERY performance

when I issue a join query between T1(87 rows) and a
subselect(x10^6 rows)
the optimizer estimation row count is only 1
the query has to scan the primary clustered indexes in
all the tables that partcipate in the subselect (no other
way).
I already rum update statistics on all the objects
involved without success
that causes the server to use T1 as the outher table in a
nested loop join which makes the query run for 10 hours
instead of 10 minutes
Any ideas?Perhaps you could try updating the statistics with the FULLSCAN option?
Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup
"Amit" <amit.eshet@.intel.com> wrote in message
news:190f101c44c8e$c9932ff0$a401280a@.phx
.gbl...
> when I issue a join query between T1(87 rows) and a
> subselect(x10^6 rows)
> the optimizer estimation row count is only 1
> the query has to scan the primary clustered indexes in
> all the tables that partcipate in the subselect (no other
> way).
> I already rum update statistics on all the objects
> involved without success
> that causes the server to use T1 as the outher table in a
> nested loop join which makes the query run for 10 hours
> instead of 10 minutes
> Any ideas?