| Performance issue [message #321990] |
Thu, 22 May 2008 01:27  |
manoj12
Messages: 210
Registered: March 2008
Location: India
|
Senior Member |
|
|
Dear sir
The very first time when I fire a select statement the time taken for retrieving the query is 0.063 seconds and the second time if I again fire the query the time taken is 0.00 seconds because there is a reason to it.The reason is that if data is not there in database buffer cache it is loaded from the data files.Now I wanted to know that Is the time taken to retrieve the query is the write time or I need to use hint to reduce the time?.
Has oracle have any rule so that I should come to know that this hint is more superior than any other hint?.
[Updated on: Thu, 22 May 2008 01:28] Report message to a moderator |
|
|
|
|
|
| Re: Performance issue [message #322027 is a reply to message #322008] |
Thu, 22 May 2008 03:53  |
manoj12
Messages: 210
Registered: March 2008
Location: India
|
Senior Member |
|
|
Dear Sir
Sorry for the inconvenience sir.
I mean to say that Is the time taken to retrieve the query is the correct time or I need to use any performance hint which will reduce the execution time of the query?
Regards
[Updated on: Thu, 22 May 2008 03:55] Report message to a moderator |
|
|
|
| Re: Performance issue [message #322030 is a reply to message #322027] |
Thu, 22 May 2008 04:05 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | I mean to say that Is the time taken to retrieve the query is the correct time or I need to use any performance hint which will reduce the execution time of the query?
|
If there would be a performance hint that ensure a reduction of execution time then it would be always on and there would be no more use of this hint (unless you wanted to keep the possibility to slow down your query).
Regards
Michel
[Updated on: Thu, 22 May 2008 04:05] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
