At first blush, your problem would appear to concern the lack of index-use.
That's where I would begin my investigation. It might be painstaking, but
I would do something like this:
For each view
Look at the Join(s) and see what columns are being joined
Look at the tables and see what col
Hi all,
I've got some semi-general questions on the topics in the title. What I'm
looking for is more in the line of theory than query specifics. I am but a
poor peasant boy.
What I have is an application that makes heavy use of views. If I understand
views correctly (and I may not), views
