Interested to Buy Any Domain ? << Click Here >> for more details...
when i run my query on yesterday it is fast but today it is
slow why?
- 1 Answers
- 7598 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 |
Name the various constraints used in oracle?
How can I introduce multiple conditions in like operator?
What are the data types in oracle?
3. Display all the client numbers in the ORDER table. Remove duplicates.
how to clone 9i Database on to 10g Database.
what are actual and formal parameters?
What is set verify off in oracle?
How do I spool to a csv formatted file using sqlplus?
What is index in Oracle?
How remove data files before opening a database?
Is truncate autocommit in oracle?
How do you store pictures in a database?
Oracle General 
