Re: How to optimize queries with ORDER BY field DESC

From: <frleong_at_bigfoot.com>
Date: Tue, 15 Sep 1998 03:56:19 GMT
Message-ID: <6tkoh3$os3$1@nnrp1.dejanews.com>

Thank you! It worked but I must use order by DESC because the SQL statement is not generated by me. I was wondering if there is any other way to "teach" Oracle to be smarter.

Francisco Leong

In article <6tia0h$mal$1_at_news.kren.nm.kr>, "Young-chul,Jun" <ycjun_at_hotmail.com> wrote:
> Hello :)
>
> In my opinion..
> Hint Statement will help you.
> DESC is not necessary to solve it :)
>
> select /*+INDEX_DESC (Table1 index_name)*/ columns...
> where id < something
>

--
---
frleong_at_bigfoot.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 22:56:19 CDT