Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of manish.khettry@gmail.com
 designates 64.233.184.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=GPI6EnHFh4KQlMCY4ZsXo4oLBKFE0xfxOxMMhTqmQ/IexJbTFp/xdl+3BiEXPZ7X6yWfo9bqRhNo2iHperYqlMhHLadEOTmRruTi94tGUbDOEa+uOlFR7K38X91vmpe62tSF/OfAPskioJjQMep3pPi8TGG3pU293REba7VnajI=
Message-ID: <ee5641605072618385d94faa2@mail.gmail.com>
Date: Tue, 26 Jul 2005 18:38:33 -0700
From: Manish Khettry <manish.khettry@gmail.com>
Reply-To: Manish Khettry <manish.khettry@gmail.com>
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: [jira] Commented: (DERBY-472) Full Text Indexing / Full Text
 Search
In-Reply-To: <42E6C991.6050703@debrunners.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <2127757367.1122418458423.JavaMail.jira@ajax.apache.org>
	 <42E6C516.50506@sbcglobal.net> <42E6C991.6050703@debrunners.com>

> > 2) Would there be work in the optimizer to get it to recognize that
> > there was an index that helped with the CONTAINS() function.  Is this
> > the sort of work needed for DERBY-455 creation of indexes on expression=
s?
>=20
> Possibly.
>=20
> Dan.
>=20

I would think that each secondary access method would have a set of
functions that could be used to read from the index. Much like BTree
has <, <=3D, =3D and others, a text index would have CONTAINS (maybe
others).

The optimizer would have to know that CONTAINS is one of the functions
supported by the index and to consider the access path when
considering query plans.

Manish