David, Thanks! 'EXPLAIN ANALYZE' is very slick. Promises to be very helpful. As soon as I saw the output, it was obvious where my problem was.
Brad. On Mon, Mar 6, 2023 at 2:30 PM David G. Johnston <david.g.johns...@gmail.com> wrote: > 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. >
