On Mon, Mar 6, 2023 at 1:18 PM Brad White <b55white(at)gmail(dot)com> wrote:
>
> As you can see here, when attempting to filter on the FileKey, it is
> actually filtering on the Order Item ID field.
>
> select "FileKey", "OrderItemID" from "vw_rptInvc_Permits"
> where "FileKey" LIKE '%1317'
>
> I'm stumped. Any guesses?
>
Agreed, what you've shown doesn't make sense.
Try:
EXPLAIN ANALYZE
REINDEX (on any underlying table indexes)
Show the version you are running.
David J.