January 5, 2009 at 10:23 pm
I have two really huge views which access many tables.The views execute fine individually, they execute in less than a sec when queried separately.but I have a requirement where I need to join these 2 views but that takes about 7-8 secs(not acceptable time) to execute.Can someone tell me what could be wrong?
Thanks,
ssm
January 6, 2009 at 12:53 am
Are the 2 views accessing the same table 2 times? Sometimes when you join views you actually are better off writing the whole query without the views. Views are good for abstracting data access and security, but are not always good for performance.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply