Enron email

Algorithmic Indexing

23 Jan 2002, 23:27 UTC

portcalc

From
Francis S. Lim s..lim@enron.com
To
Errol McLaughlin
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