rogv24_at_yahoo.com wrote in
news:1192114370.994565.305400_at_19g2000hsx.googlegroups.com:
> On Oct 11, 9:12 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>> On Oct 11, 7:56 am, sybrandb <sybra..._at_gmail.com> wrote:
>>
>>
>>
>>
>>
>> > On Oct 11, 4:54 am, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
>>
>> > > rog..._at_yahoo.com wrote in news:1192048135.946395.141040
>> > > @o3g2000hsb.googlegroups.com:
>>
>> > > > There is a sql script that updates a file and it took 20
>> > > > minutes
>> > > > about 10 days ago.
>>
>> > > > With a few more records that are updated it too 190 minutes
>> > > > on the
>> > > > same server.
>>
>> > > > Can any one think what could possibly could cause this?
>> > > > thanks.
>>
>> > > My blue 2-door car used to be fast & now it goes slow.
>> > > Can any one think what could possibly could cause this?
>>
>> > Did you put a brick on the brakes?
>>
>> > --
>> > Sybrand Bakker
>> > Senior Oracle DBA
>>
>> Geez, the reason is obvious:
>>
>> The atmospheric conditions in Zimbabwe no longer favor blue, two-door
>> vehicles, therefore all such vehicles in Duluth will be travel
>> slower.
>>
>> David Fitzjarrell- Hide quoted text -
>>
>> - Show quoted text -
>
>
>
> What has the operating system go to do with this??????? What has the
> code go to do with this?????? Even if I give you this info will you
> be able to tell me why its so slow????
>
>
Without fact, the best that can be done is random guesses.
To obtain facts enable SQL_TRACE & run the results thru TKPROF
in order to see where the time is being spent.
Post the EXPLAIN PLAN.
Are statistics current on both table & indexes?
Received on Thu Oct 11 2007 - 10:01:50 CDT