-
executes
My query never executes and takes a long time, What could I do?
Milinda
-
You could learn to RTFM, and stop bombarding us with your generic class assignment questions.
-
Sites
Thanks for ur help, Actually I am new to this, Sorry If I disturb u people. I go through sites u gave me.
Milinda
-
Re: executes
Originally posted by milinda
My query never executes and takes a long time, What could I do?
Tell it to execute and take a less time (In the code I mean)
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
What does the data look like??? How many rows in the tables ???
What does the query look like??? Are you using cost or rule
based optimization??? Are you statistics updated ???
What does the execution plan look like ???
If you are using multiple table joins, you should try to use
the "smallest - least rows returned" table as the driving table...
Have you looked at the "explain plan" to see the path Oracle is
taking? Have you tried "Hints" ...
What does that SGA look like .......
There are many different reasons for a query to be slow ...
Gregg
-
My query never executes and takes a long time, What could I do?
paste ur query and the no. of records in the tables used by the query.
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|