This has been running for 90 minutes. My sql in Toad for Oracle has probably double the amount of columns and completes in 8 minutes
SELECT MME_MAF.datetime , MME_MAF.mme
,sum(MME_MAF.vs_attpaging_firstattempt)
,sum(MME_MAF.vs_nbrpagingto_firstattempt)
,sum(MME_MAF.vs_attpaging_secondattempt)
,sum(MME_MAF.vs_nbrpagingto_secondattempt)
,sum(MME_MAF.vs_nbrsuccessattachrequests)
,sum(MME_MAF.vs_attattachrequests)
,sum(MME_MAF_1.VS_NBRFAILATACHREQ_ILLEGALME)
,sum(MME_MAF_1.VS_NBRFLATCHREQS_EPSSRVCNTALW)
,sum(MME_MAF_1.VS_NBRFLATHRQ_EPSNDNONEPSNTALW)
,sum(MME_MAF_1.VS_NBRFAILATCHREQS_PLMNNTALOW)
,sum(MME_MAF_1.VS_NBRFAILATCHREQS_TANTALOW)
,sum(MME_MAF_1.VS_NBRFLATCHRQ_ROAMNGNTALWEDTA)
,sum(MME_MAF_1.VS_NBRFLATCHRQ_EPSSRVNTALWPLMN)
,sum(MME_MAF_2_1.VS_ATCESMFL_MISINGORUNKNWAPN)
,sum(MME_MAF_2_1.VS_ATCESMFL_UNKNOWNPDNTYPE)
,sum(MME_MAF_2_1.VS_ATCESMFL_SVCOPTNTSUPORTED)
,sum(MME_MAF_2_1.VS_ATCESMFL_SVCOPTNTSUBSCRBD)
,sum(MME_MAF1.VS_RAUINTRASGWATTS3)
,sum(MME_MAF1.VS_RAUINTRASGWSUCCS3)
,sum(MME_MAF1.VS_RAUINTERSGWATTS3)
,sum(MME_MAF1.VS_RAUINTERSGWSUCCS3)
,sum(MME_MAF2.VS_TAUATTS3)
,sum(MME_MAF2.VS_TAUSUCCS3)
,sum(MME_MAF_1_1.VS_NBRFAILEDATTACHREQUESTS_SUM)
,sum(MME_MAF_1_1.VS_ATTNONEPSATTACH)
,sum(MME_MAF_1_1.VS_NBRFAILNONEPSATCH_ILLEGALUE)
FROM
((((PDW_ALUMME_VIEWS.MME_MAF MME_MAF
INNER
JOIN
PDW_ALUMME_VIEWS.MME_MAF2 MME_MAF2
ON (MME_MAF.datetime = MME_MAF2.DATETIME) AND (MME_MAF.mme = MME_MAF2.MME))
INNER
JOIN
PDW_ALUMME_VIEWS.MME_MAF_1 MME_MAF_1
ON (MME_MAF.datetime = MME_MAF_1.DATETIME) AND (MME_MAF.mme = MME_MAF_1.MME))
INNER
JOIN
PDW_ALUMME_VIEWS.MME_MAF_2_1 MME_MAF_2_1
ON (MME_MAF.datetime = MME_MAF_2_1.DATETIME) AND (MME_MAF.mme = MME_MAF_2_1.MME))
INNER
JOIN
PDW_ALUMME_VIEWS.MME_MAF1 MME_MAF1
ON (MME_MAF.datetime = MME_MAF1.DATETIME) AND (MME_MAF.mme = MME_MAF1.MME))
INNER
JOIN
PDW_ALUMME_VIEWS.MME_MAF_1_1 MME_MAF_1_1
ON (MME_MAF.datetime = MME_MAF_1_1.DATETIME) AND (MME_MAF.mme = MME_MAF_1_1.MME)
where
MME_MAF.datetime >= trunc(sysdate-6)
group
by MME_MAF.datetime,MME_MAF.mme
Mark Fringer
AT&T Network Operations
Operational Certification and Advanced Technical Support (OCATS)
Nokia (fALU) Core
708-240-7598 - SKYPE Number
815-715-8048 - Cell Number
This email and any files transmitted with it are AT&T property, are
confidential, and are intended solely for the use of the individual or
entity to whom this email is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have received
this message in error, please notify the sender and delete this message
immediately from your computer. Any other use, retention,
dissemination, forwarding, printing or copying of this email is strictly
prohibited.
From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]
Sent: Tuesday, May 23, 2017 12:05 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] failing query
RE: failing query
Reply by Aleksey Bazhenov
Could you provide more information?
Could you post the original query, the changed one and screenshot with the error?
There is no limit on number of tables in Query Builder. What happened when you added the 6-th table to Query builder? Could you post the screenshot with Query builder and all added tables?
Regards
Aleksey
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Point Forum notifications altogether.
Toad Data Point - Discussion Forum
Flag
this post as spam/abuse.