Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.berkeley.edu!ucberkeley!sn-xit-02!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Performance problem: anything else I can do to make this faster? Date: Thu, 03 Mar 2005 17:24:48 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1109899299.932610@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1109793882.803053.240440@l41g2000cwc.googlegroups.com> <1109799052.789107.250590@o13g2000cwo.googlegroups.com> <00fc2196m32dguelv7p3uqbqbdla0unnvi@4ax.com> <1109805174.099516.303550@f14g2000cwb.googlegroups.com> <1109805606.965366.268740@o13g2000cwo.googlegroups.com> <1109871953.020529.138170@o13g2000cwo.googlegroups.com> <1109882876.581831@yasure> <1109886785.028064.192750@g14g2000cwa.googlegroups.com> In-Reply-To: <1109886785.028064.192750@g14g2000cwa.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 17 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237441 sconover@gmail.com wrote: > Dan - which index did I miss? > > -Steve My copy of SQL*Plus can't connect to your instance. So how can I possibly know what indexes, of what index types, with what column orders exist? And then we can discuss cardinality, and whether your statistics are current and collected with DBMS_STATS. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)