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