Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT TI SUE;
If Sue needs to select from Scott's DEPT table, which command should she use?
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 considered. t t t ...
ABAP PERFORMANCE ISSUES
ABAP/4 Optimization Use the GET RUN TIME command to help evaluate performance. It's hard to know whether that optimization technique REALLY helps unless you test it out. Using this tool can help you...
Determine the most Critical SQL Statements
It is always good to determine the most exclusive SQL statements in terms of elapsed time and checking the result list top down, For a technical SQL optimization. The most expensive SQL statements in...