Oracle Query Performance Tuning 105 FUNCTION-BASED INDEX, EXPLAIN PLAN PREDICATE, AND LONG COLUMN
What is an Execution Plan Predicate and how do you use it to create a function-based index?
Let's find out in today's session.
Also how to use LONG column in a SELECT statement using built-in function.
LONG datatype is deprecated in Oracle due to many restrictions and limitations.
However metadata tables still use them and SELECT query will generate the error below.
ORA-00932: inconsistent datatypes: expected CHAR got LONG
This video is a continuation from my previous video.
Link to my previous video.
Watch video Oracle Query Performance Tuning 105 FUNCTION-BASED INDEX, EXPLAIN PLAN PREDICATE, AND LONG COLUMN online without registration, duration 09 minute 59 second in high hd quality. This video was added by user Ken Kim 30 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 65 once and liked it 2 people.