> We are getting the following error during a SELECT-query and gfix with > gback do not fix it. > > org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544343. invalid > request BLR at offset 226 > there is no index IDX_p39A2dTscKu7xw43c5lrjQ== for table COPY > > The customer is really frustrated, what should we do?
Are you forcing the optimizer to use an index via an explicit PLAN, but the index doesn't exist? Regards, Thomas