Message-ID: <16581793.1075841229454.JavaMail.evans@thyme>
Date: Wed, 23 Jan 2002 15:27:18 -0800 (PST)
From: s..lim@enron.com
To: errol.mclaughlin@enron.com
Subject: portcalc
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Lim, Francis S. </O=ENRON/OU=NA/CN=RECIPIENTS/CN=FLIM>
X-To: McLaughlin Jr., Errol </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Emclaug>
X-cc: 
X-bcc: 
X-Folder: \ExMerge - McLaughlin Jr., Errol\Deleted Items
X-Origin: MCLAUGHLIN-E
X-FileName: erol mclaughlin 6-26-02.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