Archive for sql
You are browsing the archives of sql.
Oracle deadlocks: the what and the how
Everyone knows what a deadlock is: a situation in which two or more competing processes are waiting for the other to finish, and thus neither ever does. The purpose of this post is to help people understanding the deadlock a little better with a view to enable them to fix the problem when they find [...]
Performance tuning SQL queries in Oracle
Video tutorial showing how to optimise your SQL queries for maximum performance. Talks about indexes, statistics, hints and optimiser plans.
Using SQL potential
How to use the database SQL to its full potential. The idea is to reduce procedural coding and thereby improve performance, reduce defects.
