On Mon, Mar 6, 2023 at 1:18 PM Brad White <b55white@xxxxxxxxx> 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.
