一个临时的解决方法是优化数据库表(就像以前做的)。
A short term fix (as has been done before), is to optimize the database tables.
此脚本创建优化的SQL以用于查询,而不需要在数据库中创建额外的视图或表。
This script creates optimized SQL to be used for the queries, without needing extra views or tables created in the database.
更新数据库服务器用于优化查询的系统编目表。
Update system catalog tables that the database server USES to optimize queries.
相反,优化器将对查询中引用的每个数据库表收集最新的统计数据。
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.
访问方法是指优化器从数据库表中读取(更确切地说是检索)数据的方法。
Access methods refer to the ways that the optimizer reads (or rather retrieves) data from database tables.
这就意味着您需要以这样的方式设计数据库系统,即将数据库表划分成两种类型——静态和动态——的模块化、最优化部分。
This means you need to design the database system in such a way that you divide the database tables into modularized and optimized partitions of two types — static and dynamic.
数据库开发人员——负责实际运行的数据库,包括设计数据库、模式、表、表关系、索引,以及对查询进行优化。
Database developer — Responsible for the actual databases in operation, including designing databases, schemas, tables, table relationships, and indexes as well as optimizing queries.
exe检查数据库是否健康,比如检查、修复、分析或优化表。
Mysqlcheck.exe Checks for database health, for example to check, repair, analyze, or optimize tables.
表之间的关系提供了Teradata数据库优化器的输入值。
Relationships between tables provide valuable input to the Teradata database optimizer.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成,那么数据库优化则必须包含实体化。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
紧凑的数据表可以针对基于行的数据库做存储块优化,让SQL执行得更好。
Compact tables can optimize storage blocks for row-based databases and accordingly make SQL perform better.
已经恢复正常。我们优化了数据库表并对数据库进行了备份。
Work is flowing again. We optimized database tables and backed up the database.
停机时间将可能比以往的更长,因为除了备份数据库以及优化数据表,我们还要将项目文件移动至文件服务器上。
Today's down time is expected to be a bit longer than usual because, in addition to backing up our database and optimizing tables, we are also going to move our project files over to the file server.
用当前最优化的设置备份数据库,不备份TOOLS表空间。
What can you do to skip backing up the TOOLS tablespace without changing the current backup optimization setting?
用当前最优化的设置备份数据库,不备份TOOLS表空间。
What can you do to skip backing up the TOOLS tablespace without changing the current backup optimization setting?
应用推荐