Topic |
Description |
|
| 25/02/2008 | Its a tough business being the explain plan output |
|
| 15/10/2007 | A little oddity with the X$ tables |
|
| 18/04/2007 | Subtle differences in cursor sharing with dynamic SQL |
|
| 09/01/2007 | You need to very careful when collecting stats on function-based indexes |
|
| 09/01/2007 | Is it really better than insert-update ? |
|
| 05/08/2006 | Data type conversion is not free...even for static literals |
|
| 19/01/2006 | Using a global temporary table for your plan table |
|
| 08/09/2005 | (Updated) How to make your import's scream along |
|
| 14/06/2005 | A cute trick for arbitrary number of rows |
|
| 17/04/2005 | NVL seems to have got smarter |
|
| 21/01/2005 | A newsgroup post claimed rebuilding an index changed the clustering factor - here's how |
|
| 27/06/2004 | The CBO can be too smart for its own good sometimes |
|
| 27/06/2004 | The LIKE predicate has a special case for two leading characters |
|
| 06/04/2004 | Think the lowest cost is the one CBO always chooses? Think again |
|
| 01/01/2003 | A 9i enhancement to tkprof to allow it see wait information |
|
| 10/09/2002 | (Updated) Tune SQL's in pre-delivered applications without changing the code |
|
| 14/03/2002 | Got a low hit ratio - this routine can help |
|
| 04/11/2001 | The world's worst PL/SQL routine |
|
| 01/10/2001 | Some notes on choosing the best value for this parameter |
|
| 10/05/2001 | A hidden parameter that may assist with high version counts |
|
| 27/03/2001 | Careful with your FBI's until 8.1.7.2 |
|
| 04/03/2001 | A tool to determine to optimal compression for indexes |
|
| 08/12/2000 | Count(*) versus count(primary_key_col) vs count(...) - what's the best |
|
| 22/11/2000 | We all know that using literals in SQL is bad...but how do we find them? |
|
| 14/11/2000 | Trying to avoid the pain of index rebuilds ? The new COALESCE option may be for you |
|
| 10/11/2000 | A bug with index statistics when the index is compressed |
|
| 08/11/2000 | A starting point in knowing which indexes are being used |
|
| 03/11/2000 | An often overlooked area that affects the decisions of the cost optimizer |
|
| 02/11/2000 | Dunno why, dunno how, but this table has part of a row |
|
| 19/09/2000 | PL/SQL is very fast, but not infinitely fast... |
|
| 01/09/2000 | An interesting quirk with statistics on partitioned indexes |
|
| 03/08/2000 | Tune SQL's in pre-delivered applications without changing the code |
|
| 24/07/2000 | Some 8i triggers to assist with shared pool management |
|
| 21/06/2000 | DBA_SEGMENTS running like a wet sponge? This script can help |
|
| 11/06/2000 | Using an 8i feature to produce a trace file whenever a specific user connects |
|
| 20/05/2000 | What rollback segment is someone using |
|
| 24/04/2000 | How to ensure that all developers can see their trace files without DBA access |
|
| 01/03/2000 | A couple of hints to make your indexes faster and smaller |
|
| 24/02/2000 | How to make your import's scream along |
|
| 10/02/2000 | Reducing contention problems with the library cache (especially on small systems) |
|
| 09/02/2000 | A couple of registry tweaks to improve NTFS performance |
|
| 06/02/2000 | Forcing the order of predicates in SQL |
|
(always more to come...) |
|