Had to touch the trial balance report and I cannot wipe the stain off my fingers.
My gl table in one of our companies maintains about 450 mill rows per year and the indexes I want I cannot add in for fear of potential disk loss. We have 7 years of gl data. I can select the raw rows in a Select * from Where t_yer = 2014 and get them in just over 2 min. Or I Pre-Sum the bastards with a group by and only bring back 48 thousand rows in 20 seconds. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+FHN=PVekP=cmywkwvynjwfqzas_uhrpjzrmpl3x1...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
