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 a Tablespace?
How to start a specific oracle instance?
Can we create more than one index on particular column?
How do I manually uninstall oracle client?
What is open database communication (odbc) in oracle?
What are joins, explain all types of joins?
how to retrieve data from different tables ,place this data in different excel worksheets.
Can a field be used in a report without it appearing in any data group ?
What is concurrency in oracle?
How to start an oracle instance?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
Explain the use of grant option in exp command.