In this SQL Optimizer for SAP ASE video, we demonstrate how to use the SQL formatter to transform SQL code into a more readable format.
Related Articles
Index selectivity & queries with multiple equality conditions
Performance of a query having multiple equality type predicates improves as it switches from using the index on an unselective column to a selective one. It is very common to issue queries with multi...
SQL Optimizer for Oracle – Optimize SQL (SQL Rewrite)
Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL Optimizer generates semantically equivalent alternatives with unique execution plans for your original SQL statemen...
Database Administrators and the Cloud
There’s no fighting progress. Decades ago database administrators managed and controlled everything – the OS, network, storage and database. Times have changed and DBAs have had to evolve (i.e. accept...
