Re: O9i: general index question

sybrandb@xxxxxxxxx schrieb am 28.03.2007 in <3v7l03hnh3bgc08tmhkj46u3653m1a8mpo@xxxxxxx>:

On Wed, 28 Mar 2007 17:57:21 +0200, Andreas Mosmann
<mosmann@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

function based index on id_master
decode(id_master,'0','0',null)
I tried it but Oracle did not use this Index :(
CREATE INDEX MyIndex ON TREES (DECODE(IDPARKING,'P0',NULL,IDPARKING))
because I only want to have trees on PARKINGs (about 0.01%)

NULL values are not indexed.
now I try to replace R0 by NULL

Obviously you where clause would need the above predicate for the FBI
to be used (and query_rewrite should be set to true)
Sorry, I did not understand correctly. The WHERE clause is still the following:
WHERE IDPARKING = 'P0' so I would hope it finds out that MyIndex fits. with query_rewrite I played never before, I will try it out.

Thank you
Andreas Mosmann



--
wenn email, dann AndreasMosmann <bei> web <punkt> de
.

Relevant Pages

  • Re: make 100 by using 1, 7, 7, 7, 7
    ... Kira Yamato writes: ... dangerousgam...@xxxxxxxxx schrieb: ... a way to list out all possible trees with 7 leaves. ... res:= res union; ...
    (sci.math)
  • Re: VW scheitert an Spritverbrauch
    ... Roland Mösl schrieb am Fri, ... No trees were killed in the sending of this message. ... a large number of electrons were terribly inconvenienced. ...
    (de.etc.fahrzeug.auto)
  • Re: Using a Structure in a Class
    ... "Ren" schrieb ... I realized just as I hit "send" on my post ... Too many trees to see the wood. ...
    (microsoft.public.dotnet.languages.vb)