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
Joint DataSets or SQL Query Joins?
Migrateduser
<p>Hi Sir,<br><br>
I wanted to know if there is any noticable performace issue of creating a Joint Datasets using different datasets over adding Joins at query level?<br><br>
And also what is the best approch to use Joint Datasets,</p>
<p>I am using Vertical Inheritance in Database,</p>
<p>So I have an entity called Applicant which further have sub-entities Person and Company, and Applicant has Applications and Documents,</p>
<p>In the end I want to allow user to select ApplicantType(Which is a filed in Applicant to define different types or applicants) and then search for applications or documents</p>
<p> </p>
<p>Thanks,</p>
<p>
Saif.</p>
Find more posts tagged with
Comments
There are no comments yet