Find Detail on Tables Used in View
I am in need to optimize a view that... let's just say it "lost it's way." It is now in need of optimizing. Is there a way I can find what tables/columns are being used in what reports? I do not know if in modifying the view I will break any existing reports. I know how to see what reports are being used, just not what tables. I am competent in DB use as well....