#DateForumTypeThreadPost
521 May 2012 @ 02:15 PDTDatabaseTopicCollect stats on column vs on index I have a table with primary and secondary indexes defined on it. Something like: CREATE TABLE DB1.TBL1 (COL1 INTEGER, COL2 CHAR(10), COL3..... COL10) UNIQUE PRIMARY INDEX PMY_idx (...
418 Sep 2011 @ 10:35 PDTDatabaseReplyCPU utilization by a query Thanks for the inputs. Can we find out the CPU cycles consumed by a query, directly or indirectly? AMPCPUTime and ParserCPUTime are available in DBC.QryLog view but I couldn't find ...
313 Sep 2011 @ 03:16 PDTDatabaseTopicCPU utilization by a query Hi experts, I understand that the CPU utilized by a query can be determined by adding AMPCPUTime and ParserCPUTime. If I get a value of 100 does this mean that the CPU was processing the que...
228 Aug 2011 @ 11:00 PDTDatabaseReplyCalculate query dollar cost Thanks for you suggestion. I am not sure if I would have access to the annual cost related information, but no harm in trying to find out. Had there been any standard benchmark available...
123 Aug 2011 @ 11:54 PDTDatabaseTopicCalculate query dollar costHi, Through a performance improvement exercise we were able to bring down the system resources - CPU and IO used by a set of queries. We have recorded the saving in terms of Total CPU time and T...