From: buckeye234 Newsgroups: comp.databases.oracle.server Subject: Re: Performance Date: Mon, 09 Sep 2002 17:19:55 +0000 Organization: dBforums Lines: 15 Sender: buckeye234 Message-ID: <1793411.1031591995@dbforums.com> References: NNTP-Posting-Host: p-228.newsdawg.com User-Agent: dBforums X-Original-NNTP-Posting-Host: ns.spikeball.com X-Original-Trace: 9 Sep 2002 17:21:07 GMT, ns.spikeball.com How are you timing the query? Are you in SQL*Plus and watching the data go by? If so, it's the movement of the data to SQL*Plus and the display to the screen that is taking so long. If not, please try to provide more detail on how you are doing the timing. The version of the database. The OS and the machine on which the database is being run. Later, Patrick -- Posted via http://dbforums.com