Home » SQL & PL/SQL » SQL & PL/SQL » long query runing (oracle)
long query runing [message #424222] Wed, 30 September 2009 19:56 Go to next message
yurkoz
Messages: 26
Registered: September 2009
Location: bronx
Junior Member
I am beginer ,and I have simple question.
If my query running really slow.
and during the time my query run, sumbody update tne
table, that I use in from.
My result would reflect this changes?
Thanks



Re: long query runing [message #424223 is a reply to message #424222] Wed, 30 September 2009 20:00 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>My result would reflect this changes?
No, your results will NOT include any change made after your query started.

Read The Fine Manual - Concepts Manual
found at http://tahiti.oracle.com

Re: long query runing [message #424302 is a reply to message #424222] Thu, 01 October 2009 06:59 Go to previous message
yurkoz
Messages: 26
Registered: September 2009
Location: bronx
Junior Member
thank you BlackSwan
Previous Topic: My Simple query takes 30 min to run
Next Topic: problem in analytic query
Goto Forum:
  


Current Time: Fri Dec 02 18:18:45 CST 2016

Total time taken to generate the page: 0.46329 seconds