|
How Do I Make It To Run Faster?
It should be accepted that if you wanna have high performance
application, then you should be faithful your nice demand at the
beginning of the voyage.Not at the end...
I mean, All performance gains are to be realized at the design
and implementation level – not the database level.
ýt is said that you cannot tune the database until you
run the database.
But in database level some changes can be done
For ex:SELECT * FROM EMP WHERE EMPNO = 1234
The above query will be aoutomatically converted to the
SELECT * FROM EMP WHERE EMPNO = :x
if you set CURSOR_SHARING=FORCE and the number of hard parses
will decrease but when you set this; some information is removed
from the query and replaced with bind variables. And when the user
itsef uses Auto binding this set works more slower.
As it seen there is no such straightforward method that always
run well and you should be aware what did you do, and afterwords
do the manuplations in the database level.
From different perpective if there is such method to make run the
system faster everytime then oracle will use it as a default :)
|
