Re: Oracle Index Question

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 08 Feb 2007 12:02:08 +0100
Message-ID: <530e92F1pp37kU1@mid.individual.net>

On 07.02.2007 23:25, Muggle wrote:
> On Feb 7, 4:36 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> Again you did not get what I mentioned in my OP. I was talking about
> adding filter criteria on indexed columns.

Ah, ok. Sorry for that. It was late and I was tired and there was no DDL posted.

To answer your question: as I said, generally adding a filter on a column with an index reduces likelihood of a FTS. Also, reducing the amount of data selected also reduces the likelihood of a FTS. What actually happens depends on the DDL, data, Oracle version, configuration parameters and probably even more things.

Kind regards

robert Received on Thu Feb 08 2007 - 05:02:08 CST