when i run my query on yesterday it is fast but today it is
slow why?
- 1 Answers
- 6772 Views
- I also Faced
- E-Mail Answers
Answer / chockalingam
There might be several reasons for the dealy
1) Network might be slower today compared to yesterday
2) Data might have increased substantially
3) Concorrent users might be running the query at the same
time
4) There might be lock established on the table from
another resource
5) temp memory might be less today. May be Server space
related issue.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is oracle datasource?
How to define an anonymous procedure with variables?
What is snapshot is too old? Give and example for better understand.
What are the components of Logical database structure of ORACLE database?
How to sort output in descending order in oracle?
What are set operators?
Are truncate and delete commands same? If so why?
What does COMMIT do ?
What is an Index ?
What are the various constraints used in oracle?
How to use existing values in update statements using oracle?
What is the difference between online and offline backups?
Oracle General 
