The reason: Normalization requires more tables, table joins, keys and indexes and thus more internal database operations for implement queries.
其原因是:规范化需要更多的表,连接等操作,主键、索引,从而需要更多的内部操作。
NET interface for querying the datastore in a pure SQL manner, but the keys and indexes are stored in memory to provide high scalability, availability and better performance.
SQLFire提供了一个JDBC与ADO.NET接口,用于以纯s QL的方式查询数据库,但键与索引却是存放在内存中以提供高可伸缩性、可用性及更棒的性能。
Provides access to common queries based on primary keys, foreign keys, and indexes.
为基于主键、外键和索引的通用查询提供访问
Indexes on the foreign keys referencing tables with few rows have low selectivity, and the utility of requiring the index has always been questionable.
外键上的索引所引用的表行数较少,选择性较少,需要索引的实用程序一直遭受质疑。
Each designer allows creating indexes, constraints, keys, and triggers (where applicable).
每种设计器允许创建索引、约束、键和触发器(如适用)。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
Design Advisor 非常适合为数据仓库优化数据库设计,因为除了关于索引的建议之外,它还可以提供关于MQT、MDC和DPF分区键的建议。
Created the tables, primary keys, foreign keys, and indexes.
创建了表、主键、外键,和索引。
The Design Advisor now provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
除了关于索引的建议以外,Design Advisor现在还可以提供关于MQT、MDC和DPF分区键的建议。
The Design Advisor now provides advice on materialized query tables (MQTs), multidimensional clustering tables (MDCs), and Data partitioning Feature (DPF) partitioning keys, in addition to indexes.
除了索引外,Design Advisor还提供关于物化查询表(MQT)、多维集群表(MDC)和数据分区功能(DataPartitioning Feature,DPF)分区键的建议。
You can use table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.
可以使用表设计器创建、编辑或删除表、列、键、索引、关系和约束。
You can also drop primary keys, indexes, and unique constraints from the update script.
您也可以从更新指令码置放主索引键、索引和唯一的条件约束。
From table Designer, you can also right-click in the grid section to access dialog boxes through which you can create and modify relationships, constraints, indexes, and keys for the table.
从[资料表设计工具],您也可以在方格区按一下滑鼠右键,存取可用以建立和修改资料表关联性、条件约束、索引和索引键的对话方块。
Some information, like column indexes and foreign keys, is omitted.
一些信息,比如列索引和外键,省略。
Use this dialog box to create or modify indexes, primary keys, and unique keys.
使用此对话框可以创建或修改索引、主键和唯一键。
Use this dialog box to create or modify indexes, primary keys, and unique keys.
使用此对话框可以创建或修改索引、主键和唯一键。
应用推荐