SQL Query Taking Too Long

Question

Post reply

SQL Query Taking Too Long

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

SQL DJ Right there with Babe Points: 725 More actions · Answer 1

Find attached sample data for the 3 temp tables used.

I would like to obtain all data from the #BudgetAccount temp table however some data is not being displayed and i think it could be because of the Joins. I have tried the full outer join on the #MainAccount and #BudgetTable but it still leaves out some data in the #BudgetAccount temp table.

Hope it helps

Romel SSC Enthusiast Points: 150 More actions · Answer 2

at both BudgetAccount and MainAccount there are 100 rows. BudgetAccount consists 5 unique accountID and MainAccount consists of only one where as there is 104 unique AccountID in display table. So I think you didn't provided me complete set of data. here query for display table is taking fraction of second. Is your data too large to be shared? or confedential?

SQL DJ Right there with Babe Points: 725 More actions · Answer 3

SQL DJ

Right there with Babe

Points: 725

September 19, 2014 at 1:12 pm

#1746821

Romel,

What I attached was just a sample file. The data is quite large what sample size would you require to be in a position to help ?

Romel SSC Enthusiast Points: 150 More actions · Answer 4

Romel

SSC Enthusiast

Points: 150

September 19, 2014 at 11:56 pm

#1746855

A size where I can find the delay. And if BudgetAccount and MainAccount have 100 rows then display table should be based on those rows. I am really want to try helping you.