Re: Filtered Index Equivalent in Oracle
From: Mark J. Bobak <mark_at_bobak.net>
Date: Fri, 10 Feb 2023 11:40:38 -0500
Message-ID: <CAFQ5ACJBPx-PJHLx9mFrc-m=TRVHj=5oO8kQZUnwHXQU8pMprA_at_mail.gmail.com>
Date: Fri, 10 Feb 2023 11:40:38 -0500
Message-ID: <CAFQ5ACJBPx-PJHLx9mFrc-m=TRVHj=5oO8kQZUnwHXQU8pMprA_at_mail.gmail.com>
This seems to answer your question:
https://dba-presents.com/databases/oracle/41-filtered-index-equivalent-in-oracle
On Fri, Feb 10, 2023 at 11:22 AM 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-lReceived on Fri Feb 10 2023 - 17:40:38 CET