Oracle SQL Tuning with function-based indexes
Oracle function-based indexes are a super silver bullet for optimizing your SQL to do a minimum amount of I/O to get the rows that you need. Here are details on using function based indexes. Issues with function-based indexes One of the most common ......