Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Archive for: May, 2010

Oracle – Running sqlplus From UNIX bash Scripts

Oracle – Running sqlplus From UNIX bash Scripts

Today we’re going to see how to connect and run queries on a database from a UNIX bash script.

SQL Server – Determining Index Usage

SQL Server – Determining Index Usage

Indexes have large effect on each database. They can improve queries performance dramatically, but too many of them can cause performance degradation and overhead when changing data. This tip contains a script that will help you to find useful information about index usage in your database.

Log in / Advanced NewsPaper by Gabfire Themes