#DateForumTypeThreadPost
727 Dec 2010 @ 04:33 PSTUDAReplyPerformance Tuning...........for each account number?
626 Dec 2010 @ 07:16 PSTUDAReplyPerformance Tuning...........The SARG is shorthand for Search Argument, i.e. a where clause. If your query is indeed trying to find the latest account_summary_dt and account modifier_num, there are easier ways to get that ans...
524 Dec 2010 @ 03:52 PSTUDAReplyPerformance Tuning...........Have you evaluated the explain plan? What do the table demographics look like? Your group by and qualify functions are certainly part of the performance issues. Can you narrow down the results w...
423 Dec 2010 @ 02:36 PSTDatabaseReplyEfficiency of 2 queriesRun an explain on each query and see which is more efficient...You can put the code in SQL Assistant and hit F6 and it will display the optimizer's choice of most efficient execution plan along wit...
308 Dec 2006 @ 03:50 PSTTrainingReplyIs it okay to post questions and their answers from a recent exam on this forumI'm thinking NOT! When you take the test, you are required agree to a non-disclosure agreement
208 Dec 2006 @ 03:10 PSTDatabaseReplyParitition Elimination using SubstitutionYou're really not getting partition elimination with the hard-coded date. What your getting is the result of providing better information to the optimizer, it see's a date, Oh! gee I can use the pa...
108 Dec 2006 @ 02:59 PSTUDAReplyHow to remove non-numeric characters from a string? (Oracle TRANSLATE Equivlent function?)select substring(strInput from (position('(' in strinput)+1 for 3) -- returns area code || substring(strinput from position(strinput(')' in strinput +1 for 3) --returns line prefix ||...

Pages