Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amit_saini
Honored Contributor III

Performance Issue with Left Join

Hi Folks,

I'm having 45 tables in SQL named as Tab1,Tab2.....Tab45 ,which I have stored as QVD's.Each table is having column as below:

Like Tab1 is having 928 Columns , Tab2 =776  and so on.  In all the tables I'm having ID as key to connect all 45 tables.

To connect the data , I have used left join like below, but performance is too slow.

Fact:

Load ID,

XYZ

---

From

Tab1

Left Join (Fact)

Load ID,

ABC.

From

Tab2

Left Join (Fact)

Load ID,

PQR

From

Tab3

--

--

--

Left Join (Fact)

Load ID,

HGT

From

Tab45

Row size is fine ,but I'm having so many Fields and all of them are important.

Can anyone suggest other ways of handling such data???

Thanks,

Amit

2 Replies
vvira1316
Valued Contributor II

Re: Performance Issue with Left Join

Hi Amit,

Just a thought. I'm not sure if you have explored and will help to join them on database side instead of QlikView side? Maybe joining several tables at a time, may be using resident tables.

BR,

Vijay

amit_saini
Honored Contributor III

Re: Performance Issue with Left Join

Well the database is SQL , as there is limitation within SQL that user can't create more than 760 columns and this is the mail reason why the business has divided the data in 45 tables.

Thanks,

AS

Community Browser