May I know what is the use of Dynamic sql and performance tuning?
Any one who can provide me one real time Scenerio.
Please assist here, Thanks in advance.
No Comments Posted for this Article.
Tuning Expensive SQL Statements
What are typical approaches to tune expensive SQL statements?Depending on the results of the analysis of an SQL statement the following optimizations can be...
Optimizing and Tuning Tool for Oracle SQL
Hello everyone! I am looking for a simple tool that can be used as an advisor for tuning my sql statements, especially the slow ones. I have worked with a tool called Lecco by...
Database Tuning with the Oracle Tuning Pack
Preface The Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas, such as: application SQL, indexing strategies, ...
Features: - Dynamic table name - Retrieving data using a dynasmically created internal table - Dynamic WHERE, SELECT, GROUP BY, HAVING and FROM clauses NOTE: In ABAP 6.10 it is also...