Oracle – Fastest Way To Execute SQL Is? To, Not Execute It! – Query Result Cache – Part II

Before you read on, please check out my related post on "Function Result Cache". You may find it valuable in this context. Conversation sounds familiar? I am sure you have been privy to a conversation like this between an IT manager and a DBA: Manager:  My query is extremely slow. Can you make the query … Continue reading Oracle – Fastest Way To Execute SQL Is? To, Not Execute It! – Query Result Cache – Part II

Advertisements

SQL Server SSMS Templates – Get A Jump Start On Queries/Code

You are a developer or a DBA. You run queries – a lot of them. This blog post shows you how you can simplify reuse of your queries and use already pre-built ones for which you just have to pass in the specific parameter values. Frequently run queries (without SSMS templates): You run some queries … Continue reading SQL Server SSMS Templates – Get A Jump Start On Queries/Code

Oracle PL/SQL – Quantify Code Performance For Comparison Of Different Approaches – Tom Kyte’s “runstats”

Is my PL/SQL code going to perform better? I have rewritten my Oracle code. Now, how do I tell if my coding approach A is better than coding approach B? If someone were to ask you the above question, typically, you would give the following answers If one approach is faster than the other, that … Continue reading Oracle PL/SQL – Quantify Code Performance For Comparison Of Different Approaches – Tom Kyte’s “runstats”

Oracle PL/SQL – Replace GOTO’s with LOOP’s

GOTO's should not be part of any modern programming language (IMHO). They are bad for so many reasons and should be avoided at all costs. I guess they were carried over from the Assembly and later the Basic language days. Good code (procedure/function/block) should have a single entry point and a single exit point to make it … Continue reading Oracle PL/SQL – Replace GOTO’s with LOOP’s