I have created a view pulls data from two fairly large tables.
The view represents alot of data.
I have created the relationships and indexes between the two tables.
When I run the view or try query the view from SQL Analyzer I keep getting a TIMEOUT ERROR.
Even if I return top 10
I ran the Perfmon while I was running the query and noticed that the Avg Disk Queue length
and the % processor time was peaking.
Is there a way to optimize SQL so that I am able to get large amounts of databack without it timing out.Even if it takes a while to run.