RE: NVL and index usage

2003-01-02 Thread tim
What is the difference? > > Just curios, why varchar2(1) and not char(1)? > > > Waleed > > -Original Message- > Sent: Thursday, January 02, 2003 12:48 PM > To: Multiple recipients of list ORACLE-L > > > > Does anyone know off hand if using NVL on an indexed > column negate use of

RE: NVL and index usage

2003-01-02 Thread Khedr, Waleed
Title: NVL and index usage Just curious, why varchar2(1) and not char(1)?   Regards,   Waleed -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 12:48 PMTo: Multiple recipients of list ORACLE-LSubject: NVL and index usage

RE: NVL and index usage

2003-01-02 Thread Khedr, Waleed
Title: NVL and index usage Just curios, why varchar2(1) and not char(1)?     Waleed -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 12:48 PMTo: Multiple recipients of list ORACLE-LSubject: NVL and index usage Does anyo

RE: NVL and index usage

2003-01-02 Thread Mark Richard
;Jamadagni, Rajendra" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: NVL and index usage

RE: NVL and index usage

2003-01-02 Thread Jamadagni, Rajendra
Title: RE: NVL and index usage No idea ... my guess is few years down the line, they will make it varchar2(2) ... Raj __ Rajendra Jamadagni  MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

RE: NVL and index usage

2003-01-02 Thread Jamadagni, Rajendra
Title: RE: NVL and index usage Thanks Tom and everyone ... as I mentioned they plan to use it as follows ... and nvl(new_column,'A') = nvl(some_value,'A') So I asked them to see the possibility of creating the column with a DEFAULT VALUE of 'A' so the

RE: NVL and index usage

2003-01-02 Thread Mercadante, Thomas F
rom a large table.   hope this helps.   Tom Mercadante Oracle Certified Professional -Original Message-From: Shaleen [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 1:22 PMTo: Multiple recipients of list ORACLE-LSubject: Re: NVL and index usage In a quick test on 90

Re: NVL and index usage

2003-01-02 Thread Connor McDonald
If you mean where nvl(col,:x) = :y then yes it will be negated. If memory serves, I've even had problems in the past using nvl in a function based index, the workaround doing the equivalent with decode, but I can't remember the specifics hth connor --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]>

RE: NVL and index usage

2003-01-02 Thread Jamadagni, Rajendra
Title: RE: NVL and index usage Thanks ... the development is rolling out a new change by adding a new nullable column to a table and adding following to all appropriate queries ... and nvl(new_column,'A') = nvl(some_value,'A') I learned of this few minutes ago

Re: NVL and index usage

2003-01-02 Thread Mogens Nørgaard
It won't be able to use the index as far as I know. Unless it's a functional index ;). Mogens Jamadagni, Rajendra wrote: NVL and index usage Does anyone know off hand if using NVL on an indexed column negate use of an index in CBO? This is 9202 ... and the column will be

Re: NVL and index usage

2003-01-02 Thread Shaleen
Title: NVL and index usage In a quick test on 9013 it changed the index which it was using and went from Range scan to fast full scan.   - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, January 02, 2003 9:48 AM