Re: QUERY TUNING
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Thu, 18 Dec 2008 14:06:26 +0000 (UTC)
Message-ID: <gidld2$n15$1@ss408.t-com.hr>
Date: Thu, 18 Dec 2008 14:06:26 +0000 (UTC)
Message-ID: <gidld2$n15$1@ss408.t-com.hr>
On Thu, 18 Dec 2008 02:10:24 -0800, mehraj hussain wrote:
> THEN AFTER CHECKING IT , I PLANNED TO CREATE A FUNTION BASED INDEX (MY
> bran_code COLUMN DOSNT HAVE ANY NULL VALUES) .
And what predicate do you think that the function index should help you resolve? The "!="?
-- http://mgogala.freehostia.comReceived on Thu Dec 18 2008 - 08:06:26 CST