when i run my query on yesterday it is fast but today it is
slow why?
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 schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
How to store pictures on to the database?
How to convert characters to dates in oracle?
What is oracle datasource?
Tell me New Feature of Oracle 10g?
how to find full database size
1 Answers BirlaSoft, Consultancy,
what is the syntax of SELECT command?
Point out the difference between user tables and data dictionary?
Can we connect to ORACLE db using Windows Authentication?
how to retrieve daily sal from emp table in oracle 10g
What is the exact use of Collections?
What is PL/SQL ?