23 Jan 2002, 23:27 UTC
portcalc
- From
- Francis S. Lim s..lim@enron.com
- Date
- Wed, 23 Jan 2002 15:27:18 -0800 (PST)
Errol, the post_id 1469623 is very slow because of the where clause. kindly change the where clause of this post_id from: 1=1 AND (1=1) AND commodity_cd like 'NG' to: 1=1 AND (1=1) AND commodity_cd = 'NG' this should yield the same result but it will be much faster. Francis