#DateForumTypeThreadPost
616 Jul 2015 @ 04:23 PDTDatabaseReplyPerformance QuestionHello VandeBergB, These JI and NUSI are being referenced in other downstream applications. Unfortunately, I am not authorized to post the exact definition of the view. We tried to...
516 Jun 2015 @ 03:36 PDTDatabaseReplyPerformance QuestionSorry about the long post and delay in reply. Took me some time to mock up the entire scenario since I can't post the exact table/view definitions and the original explain.
416 Jun 2015 @ 03:30 PDTDatabaseReplyPerformance QuestionHi VandeBergB,   Thanks for looking into it! DDL of the driver table looks like: /* BASE TRANSACTIONAL TABLE CONTAINING ~2BIL DATA */ CREATE SET TABLE DATABASE1.TABLE1 ,NO FALLBACK , ...
312 Jun 2015 @ 03:11 PDTDatabaseTopicPerformance QuestionHello, We have one complex view (VIEWA) created on TABLE1 (~2BIL transactional data), TABLE2 (~5K dimensional data), TABLE3 (~6K dimensional data), TABLE4 (~5K dimensional data)) and ret...
211 May 2015 @ 04:36 PDTDatabaseReplyHow to find out Active sessions at any point of time.Hello, This is what I do to find active sessions: SELECT * FROM TABLE(MonitorSession(-1, '*', 0)) AS T2;
126 Jun 2014 @ 10:54 PDTDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Hello, Based on what Adeel and Dieter mentioned, here is a script I came up with. /* CREATING SOURCE/STAGE TABLE */ CREATE VOLATILE TABLE tab1 ( Name VARCHAR(10) ) NO PRIMARY INDEX ...