emperor: (Default)

TMBSNMOTW"second"OWIWPU

posted by [personal profile] emperor at 01:48pm on 07/02/2005
I've been running some long queries on this 'ere Oracle database. Enterprise mangler provides a simple interface to the Execute plan, which I've been using since actually using EXPLAIN PLAIN looked complex. One of the columns is "Time (seconds)". A query I ran this morning said ~21,000 seconds (6 hours and a bit) but took only about 400 seconds (about 6 minutes). WTF?
Mood:: 'confused' confused
There are 13 comments on this entry.

Reply

This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting
 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

October

SunMonTueWedThuFriSat
      1
 
 2
 
 3
 
 4
 
5
 
 6
 
 7
 
 8
 
 9
 
 10
 
 11
 
12
 
 13
 
 14
 
 15
 
 16
 
 17
 
 18
 
19
 
 20
 
 21
 
 22
 
 23
 
 24
 
 25
1
26
 
 27
 
 28
 
 29
 
 30
 
 31