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@xxxxxxxxx> 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*