I have a view that is run, and works without fail for small amounts of data.
I have to run this view in order to gather data for an export I do weekly.
Lately, we've been pumping up production, so the view takes longer and
longer to run. I've reached the point now, though, that it times out while
gathering all the data.
The view gathers data from two places...tables and other views.
Is there a way I can fix this? If so, can someone help me out and give me
the 'dumbed down' version, as I'm still relatively new working with SQL
Thanks for the help.