Oracle – Facts About Primary Key vs. Unique Key You May Not Have Known

In this post we talk about Oracle specifically although some concepts apply to other databases. At a high level - PK's vs UK's Ask someone who has been doing database work about Primary Keys (PK) and Unique Keys (UK) and the differences between the two, they will tell you everything they know. Some even go into … Continue reading Oracle – Facts About Primary Key vs. Unique Key You May Not Have Known

Oracle PL/SQL – Fastest Way To Execute Code Is? To, Not Execute It! – Function Result Caches – Part I

What is the fastest way to execute a PL/SQL function? If you paid attention to the title, your answer would be “to not execute it at all”. In fact, that is the correct answer and Oracle provides the means to do it. The magic is possible because of an Oracle feature called result cache which […]

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

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”