Thanks for the responses.  These all make sense to me but unfortunately, this database lives underneath an application layer (Artiva from Ontario) so we don't have control even to look at execution plans.  We are using DBeaver to run sql but that option is not available.  I also assume we don't have access to tune the db either.