Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Performance problem with left Joins
Migrateduser
Dear All,
In my report,I am facing performance problem with more numebr of left joins.
For example, If I need to display 15 columns in my report,where these 15 columns are available in 15 different tables. So because of these 15 columns, I am performing left joins on all 15 tables. For this reason, the query will take more time to execute. This causes performance issue.
How to avoid this problem.
Regards,
Arun
Find more posts tagged with
Comments
There are no comments yet