optimization tips

[sap1958]

Lets say I have a query like this:
select name,nameplural,address,schoolName
from name_table with(nolock)
left outer join address_table on
addrid=nameid
left outer join school_table with(nolock)
on schlid=nameid

I am pulling data from 3 large tables.(name,address and school)

Any ideas on optimization (ie I am hitting three different large tables). I ask because when I put this into a crystal format, it takes forever to compile.

 

[gmmastros]

Are you joining on indexed columns? Without a where clause, This may return a lot of rows, which probably will take a long time.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sap1958]

No I am not. Is it really an involved process to use indexed columms

 

[bborissov]

And what your "Actual Execution Plan" show you, if you run that query?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.