Explain plan results
From: EdwardP <member_at_dbforums.com>
Date: 14 Jan 2002 19:14:40 -0500
Message-ID: <3c437470$1_at_usenetgateway.com>
Date: 14 Jan 2002 19:14:40 -0500
Message-ID: <3c437470$1_at_usenetgateway.com>
Hi,
I have a SQL query that I want to optimize. The query has execution time of ~ 1min 15 sec and an explain plan cost of 54,000. I created an index that I feel should improve performance. And indeed explain plan shows the cost reduction of 100 times! But the execution time has INCREASED to 5min. What is going on here?
Thanks in advance, Edward
-- Posted via dBforums http://dbforums.comReceived on Tue Jan 15 2002 - 01:14:40 CET