Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Index Question
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