![]() From the database’s perspective, that’s something entirely different.Ģ | FETCH EMPLOYEES | 1 of 1 (100.00%) | 13ģ | IXSCAN EMP_UP_NAME | 1 of 10000 (. ![]() Although there is an index on LAST_NAME, it is unusable-because the search is not on LAST_NAME but on UPPER(LAST_NAME). It is a return of our old friend the full table scan. Predicate Information (identified by operation id):ġ - filter(UPPER("LAST_NAME")='WINAND') PostgreSQL QUERY PLANįilter: (upper((last_name)::text) = 'WINAND'::text) ![]() |* 1 | TABLE ACCESS FULL| EMPLOYEES | 10 | 477 |
0 Comments
Leave a Reply. |