Functional index on MOD function with binds
From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Fri, 29 Mar 2024 13:58:29 +0530
Message-ID: <CAO8FHeXwj+N6xgzjec75eR3qrRfDZNDpUgrGzTkh0gS+DKjXww_at_mail.gmail.com>
Dear Gurus,
Date: Fri, 29 Mar 2024 13:58:29 +0530
Message-ID: <CAO8FHeXwj+N6xgzjec75eR3qrRfDZNDpUgrGzTkh0gS+DKjXww_at_mail.gmail.com>
Dear Gurus,
Need to optimise the below query , since it has mod function is used , it is possible to have functional index onit , as we could see that their is bind present in mod function , for which i doubt and may not allow to create it
SELECT *
FROM EXAM ATT
where MOD(ATT.STUDENT_ID, :B4 ) = :B3
Please let me know your thoughts on this and any other way to tune it
Regards,
Krishna
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 29 2024 - 09:28:29 CET