![]() ![]() This table tracks all loaded indices per table in the database with key metrics for monitoring. InterBase 2020 introduces "TMP$INDICES" a new system table included as part of the Performance Monitoring system tables. The new DDL syntax takes away this complexity, and provides a new "ALTER DESCRIPTION FOR" syntax that is standard across all database entities supported by InterBase. This requires the user to know the database system schema in detail for each entity type. InterBase users prior to InterBase 2020 would execute a "UPDATE SET RDB$DESCRIPTION= WHERE =", for each entity type. Starting with InterBase 2020 users can define other named tablespaces that present independent logical collections of pages. This tablespace presents a single logical collection of database pages numbered by their sequence in this collection. InterBase multifile database may be interpreted as occupying a single primary tablespace. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |