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.)

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