SET PLAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 18.15.1. Effects of Various Plan-Related the output files. The -m2 command line switch ensures that the stats and plan information derived from the SET STATS, SET PLAN and SET PLANONLY commands are also sent to the output file and not just returned -- toggle command echo on/off SET EXPLAIN -- toggle display of query access plan in the explained form SET HEADING -- toggle display of query column titles SET

............................................................................................. 274 PLAN ................................................................................................. ............................................................................................ 307 PLAN ................................................................................................. ............................................................................................ 312 PLAN .................................................................................................

VIEW 7. Операторы DML DELETE Использование COLLATE для столбцов с текстовым BLOB ORDER BY PLAN Использование алиаса делает недоступным использование полного имени таблицы RETURNING ROWS EXECUTE FIRST и SKIP GROUP BY HAVING: Более строгие правила JOIN 4 Руководство по языку SQL ORDER BY PLAN Использование алиаса делает недоступным использование полного имени таблицы ROWS UNION WITH UPDATE Изменение семантики SET Использование COLLATE для столбцов с текстовым BLOB ORDER BY PLAN Использование COLLATE для столбцов с текстовым BLOB RETURNING ROWS UPDATE OR INSERT 8

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 6.1.8. The PLAN Clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331 6.5.3. PLAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . of an index up to date is important for the optimizer’s choices in seeking the most optimal query plan. Index statistics in Firebird are not automatically recalculated in response to large batches of

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 6.1.7. The PLAN clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249 6.5.3. PLAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . of an index up to date is important for the optimizer’s choices in seeking the most optimal query plan. Index statistics in Firebird are not automatically recalculated in response to large batches of

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 270 6.1.7. Die PLAN-Klausel. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 319 6.5.3. PLAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . alias] [] [WHERE ] [GROUP BY [HAVING ]] [PLAN <plan-expr>] [UNION [{DISTINCT | ALL}] ] [ORDER BY ] [{ ROWS [TO ]

they were formerly. If you encounter an exception related to plans, e.g. Table T is not referenced in plan, it will be necessary to inspect your procedure and trigger sources and adjust the plans to make them in original database before you attempt to perform a backup/restore cycle. Plan must refer to all tables in query Using a plan without a reference to all tables in query is now illegal and will cause an Startup Menu icons by checking off the option. If you are installing on Windows 9x or WinMe, or you plan to run the server as an application in another Win32 environment, keep the icons option checked on

Cache redefined -281 335544637 no_stream_plan Table is not referenced in plan -282 335544638 stream_twice Table is referenced more than once in plan; use aliases to distinguish -282 335544643 is referenced in the plan but not the from list -284 335544642 index_unused Index cannot be used in the Firebird 1.5 Error Codes Updated 04/30/04 p. 6 specified plan -291 335544531 primary_key_notnull

must be specified -281 335544637 no_stream_plan Table %s is not referenced in plan -282 335544638 stream_twice Table %s is referenced more than once in plan; use aliases to distinguish -282 335544643 335544639 stream_not_found Table %s is referenced in the plan but not the from list -284 335544642 index_unused Index %s cannot be used in the specified plan -291 335544531 primary_key_notnull Column used in

must be specified -281 335544637 no_stream_plan Table @1 is not referenced in plan -282 335544638 stream_twice Table @1 is referenced more than once in plan; use aliases to distinguish -282 335544643 335544639 stream_not_found Table @1 is referenced in the plan but not the from list -284 335544642 index_unused Index @1 cannot be used in the specified plan -291 335544531 primary_key_notnull Column used in