'string%', it will be converted to the STARTING WITH predicate, which will use an index. This optimization only works for literal patterns, not for parameters. So, if you need to search for the beginning the author. RDB$RUNTIME BLOB A metadata description of the procedure, used internally for optimization RDB$SYSTEM_FLAG SMALLINT Indicates whether the procedure is defined by a user (value 0) or by with the EXTERNAL FILE clause RDB$RUNTIME BLOB Table metadata description, used internally for optimization RDB$EXTERNAL_DESCRIPTION BLOB Could store comments related to the external file of an external

of the author RDB$RUNTIME BLOB A metadata description of the procedure, used internally for optimization RDB$SYSTEM_FLAG SMALLINT Indicates whether the procedure is defined by a user (value 0) or by with the EXTERNAL FILE clause RDB$RUNTIME BLOB Table metadata description, used internally for optimization RDB$EXTERNAL_DESCRIPTION BLOB Could store comments related to the external file of an external