External Table
Luca's blog on data engineering, data platforms, and performance.
Links
(Move to ...)
Luca's Home Page
Luca's Twitter
Luca's GitHub
Blog of the database services at CERN
▼
Showing posts with label
SQL
.
Show all posts
Showing posts with label
SQL
.
Show all posts
Saturday, August 29, 2015
Add Color to Your SQL
›
Topic: this post is about some simple techniques to add color to SQL scripts and their terminal output using ANSI escape codes. Color...
Wednesday, September 26, 2012
Command-Line DBA Scripts
›
Topic: A review of the command-line monitoring scripts that I currently use for Oracle. Note: last updated in June 2015. Download links:...
Thursday, August 16, 2012
How to Turn Off Adaptive Cursor Sharing, Cardinality Feedback and Serial Direct Read
›
Scope: New features and improvements on the SQL (cost-based) execution engine are great. However sometimes the need comes to turn some of t...
Wednesday, July 18, 2012
Recursive Subquery Factoring, Oracle SQL and Physics
›
Introduction : this post is about the use of recursive subquery factoring (recursive common table expressions) in Oracle to find numerical ...
›
Home
View web version
