Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!fu-berlin.de!uni-berlin.de!167.167.189.69!not-for-mail From: Todd Barry Newsgroups: comp.databases.oracle.server Subject: Re: Performance problem with SQL query Date: Tue, 09 Sep 2003 12:35:27 -0700 Lines: 17 Message-ID: References: <8qnhlvsekaib23q610ci6f7t8nc80go0h9@4ax.com> NNTP-Posting-Host: 167.167.189.69 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de 1063136128 20024576 167.167.189.69 (16 [103506]) X-Newsreader: Forte Agent 1.93/32.576 English (American) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242720 Hi Mark: Yes, all the code examples are 8i-compatible. I would definitely try the ROWNUM approach first (coupled with the first_rows hint). -Todd On Tue, 9 Sep 2003 11:08:19 GMT, Mark.Wright@bristol.ac.uk wrote: >Hi Todd, thanks for all your replies! I am on holiday for this week, but >will definitely try all your ideas next week. >Are these new methods you describe all available in Oracle8i? >Also, there is little chance of me being able to alter >optimizer_index_cost_adj. I would be worried about breaking queries >elsewhere even if we had permission to get that done! >Cheers, >Mark