Home » RDBMS Server » Server Administration » Re: ORDER BY clause - easy question
Re: ORDER BY clause - easy question [message #370293] Wed, 04 August 1999 15:23
AT
Messages: 14
Registered: July 1999
Junior Member
This is a great solution, however, when I use DECODE() in the ORDER BY clause (your deluxe example), Oracle proceeds to ignore the indexes. I know that 8.1 allows indexes on functions of columns, but is there an alternative way to do this in 8.0 ? Performance, of course, is crucial and triggers/additional columns is not a good solution. Thanks in advance,
-Aung

Report message to a moderator

Previous Topic: Re: prompting in PL
Next Topic: Re: How do i breakup a TXT file and save it as multiple records?????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 08 23:01:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.