Re: Filtered Index Equivalent in Oracle

The sad answer is NO.
It's been on my wish list every since I saw it some time in about 2008. As you say, the FBI is the closest you can get, but that usually requires a change to the code to force the index to be usable.

Regards
Jonathan Lewis

On Fri, 10 Feb 2023 at 16:21, Zahir Mohideen <zahir.dba_at_gmail.com> wrote:

> Do we have a direct equivalent of "Filtered Index ( MS SQL Server)".
> The closest oracle feature is Function Based Index, I can think of.
> But , this isn't the same.
>
> Is there any similar feature in Oracle ?
>
> Thanks
>
>
> Zahir Mohideen
> http://mfzahirdba.blogspot.com/
>
>
> *Nothing so GREAT was achieved without enthusiasm*
>

--
http://www.freelists.org/webpage/oracle-l