| Performance issues with dbms_job [message #242228] |
Fri, 01 June 2007 02:49  |
|
|
Hi All,
I have implemented a job which runs every minute. That job written for a table which is important for the security purpose which deletes records of user who have more then 15 minutes of login. This means that the table is requested for the validity of the user.
So the number of rows in that table will not be on high count.
Will this job effect perforamnce of retrival of data from that table?
Database used Oracle 10g R2
regards
Amit Nanote
[Updated on: Fri, 01 June 2007 02:54] Report message to a moderator |
|
|
|
| Re: Performance issues with dbms_job [message #242234 is a reply to message #242228] |
Fri, 01 June 2007 03:29  |
 |
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
This job will have no effect on performances neither benefit nor loss.
If to retrieve the rows you use an index, the total number of rows is meaningless.
If to retrieve the rows you use a full scan, it will not change after delete.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
