|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
June 22nd, 2004, 07:28 PM
|
|||
|
|||
|
Very Slow Query
I have the query retriving Oracle Database data using SQL Plus. It runs quick but When I add one more criteria, the query become very slow and even no response.
I don't understand and I find that the table in the new criteria has index of the field. Please help!!!
__________________
Real, Nice and Beautiful are my hungry for knowledges.
|
|
#2
June 23rd, 2004, 03:08 AM
|
|||
|
|||
|
Need more details
Need more details about the table, indexes and the query if you want an effective reply. Too many variable factors to answer you otherwise.
OR, you can test your query efficiency yourself using SQL*plus by using the command: set autotrace traceonly then enter the query and check out the statistics.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Very Slow Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
