- PL/SQL
- February 5, 2026
Understanding ORACLE HINTS For JOIN OPERATIONS In Oracle Database
Oracle SQL hints are used to manually control the execution plan of a query, overriding the optimizer’s default decisions regarding…
- Performance Tuning
- November 1, 2020
Understanding INVISIBLE Index
By default an index is VISIBLE.The Oracle optimizer will pick only VISIBLE index. Oracle 11g allows indexes to be marked…
- Performance Tuning
- November 1, 2020
Understanding UNUSABLE Index
By default an index is USABLE.The Oracle optimizer will pick only USABLE index. Oracle indexes can go into a UNUSABLE…