Finding a faster query for USQL

By: Johnathon Wright on: December 17, 2012

"select sum(NOIAMOUNT) FROM NOI WHERE NOIALLOC_DATE = { d '2012-12-05' };" ~ instant

select NOITRNNUMBER, sum(NOIAMOUNT) FROM NOI WHERE NOIALLOCDATE = { d '2012-12-05' } GROUP BY NOI.NOITRN_NUMBER; ~ instant

select TRANTYPES.TRNNAME, NOITRNNUMBER, sum(NOIAMOUNT) FROM NOI, TRANTYPES WHERE NOIALLOCDATE = { d '2012-12-05' } AND TRANTYPES.TRNNUMBER = NOI.NOITRNNUMBER GROUP BY NOI.NOITRNNUMBER, TRANTYPES.TRNNAME;

~125s

select MAX(TRANTYPES.TRNNAME), NOITRNNUMBER, sum(NOIAMOUNT) FROM NOI, TRANTYPES WHERE NOIALLOCDATE = { d '2012-12-05' } AND TRANTYPES.TRNNUMBER = NOI.NOITRNNUMBER GROUP BY NOI.NOITRNNUMBER;

~ 126s





Comments:

yeezy said: I want to show my appreciation to the writer for bailing me out of this particular instance. Because of checking throughout the internet and coming across notions that were not helpful, I thought my life was done. Living devoid of the answers to the problems you have solved all through your entire posting is a critical case, as well as ones which may have in a negative way affected my entire career if I had not discovered your web page. The natural talent and kindness in maneuvering a lot of stuff was tremendous. I don't know what I would have done if I hadn't discovered such a stuff like this. I can also at this time look forward to my future. Thanks very much for this specialized and sensible guide. I will not think twice to refer your blog to anybody who would like direction on this area. yeezy [url=http://www.yeezysus.com]yeezy[/url]

supreme clothing said: Thank you so much for providing individuals with a very memorable opportunity to discover important secrets from this blog. It is often very brilliant and also packed with a good time for me personally and my office acquaintances to search your blog more than thrice in one week to see the fresh tips you have got. And indeed, I am actually amazed with the impressive techniques served by you. Certain 4 tips on this page are in truth the most impressive I've ever had. supreme clothing

kyrie 6 shoes said: I want to get across my affection for your kind-heartedness in support of persons that should have assistance with your concern. Your special commitment to getting the message up and down appears to be particularly practical and have consistently helped others just like me to achieve their pursuits. Your entire insightful guidelines denotes a lot a person like me and substantially more to my office colleagues. Thanks a ton; from each one of us. kyrie 6 shoes

yeezy shoes said: Needed to draft you a very little note to thank you so much as before regarding the stunning methods you have provided on this site. It's certainly particularly generous with people like you to supply unreservedly all a number of people would have advertised as an e book to help make some dough for themselves, certainly seeing that you could have tried it in case you desired. These solutions also served like the great way to fully grasp that other people online have the identical keenness really like my very own to grasp somewhat more concerning this condition. Certainly there are a lot more fun periods in the future for those who scan through your blog. yeezy shoes

moncler coat said: A lot of thanks for every one of your work on this web site. My mum really loves participating in internet research and it's simple to grasp why. Most people learn all concerning the powerful tactic you produce sensible guides via the website and as well as cause contribution from visitors on the theme plus my simple princess is in fact understanding a whole lot. Take advantage of the remaining portion of the new year. You're the one conducting a really great job. moncler coat

off white hoodie said: I wanted to jot down a simple comment so as to appreciate you for some of the remarkable tricks you are giving at this site. My extensive internet look up has at the end of the day been paid with wonderful details to go over with my colleagues. I would believe that many of us site visitors actually are undeniably lucky to dwell in a magnificent website with so many marvellous people with very beneficial opinions. I feel very blessed to have come across the web pages and look forward to tons of more fun minutes reading here. Thank you again for all the details. off white hoodie

kd 11 shoes said: Thank you so much for giving everyone an extremely remarkable opportunity to read articles and blog posts from this website. It is always very great and full of amusement for me personally and my office fellow workers to visit your blog nearly thrice in one week to see the new issues you have. And lastly, I'm also certainly satisfied concerning the powerful tactics you give. Some 1 facts in this posting are surely the most effective I have had. kd 11 shoes

nike off whtie said: I precisely wished to thank you so much again. I'm not certain what I would've implemented without these methods shown by you regarding my problem. It seemed to be the frustrating difficulty in my view, however , being able to view your skilled avenue you dealt with the issue forced me to jump with fulfillment. Extremely grateful for the advice as well as wish you find out what a great job you are getting into teaching some other people through the use of your websites. I am certain you have never got to know all of us. nike off whtie
Back