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.
• Oracle Query Performance Tuning 104 I...
Watch video Oracle Query Performance Tuning 105 FUNCTION-BASED INDEX, EXPLAIN PLAN PREDICATE, AND LONG COLUMN online without registration, duration hours minute second in high 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 70 once and liked it 2 people.