另外,可以修改索引和约束。
使用此对话框可以创建或修改索引、主键和唯一键。
Use this dialog box to create or modify indexes, primary keys, and unique keys.
以其他方式修改数据库,包括添加、删除或修改索引或其他约束。
Changing the database in other ways, including adding, dropping, or modifying indexes or other constraints.
此外,在DB 2中,一旦创建了索引,就不能修改索引定义中的任何子句。
Also, once an index has been created in DB2, you cannot alter any clause of the index definition.
指定的索引名称必须与当前的现有索引相同;但可以修改索引定义。
The index name specified must be the same as a currently existing index; however, the index definition can be modified.
指定的索引名称必须与当前的现有索引相同;但可以修改索引定义。
The granularity of locking used on an index can be set using the CREATE INDEX and ALTER INDEX statements.
公开的表名为“SEC”,并且需要修改索引准则,使其引用这个公开的表名,如下所示。
The exposed table name is' SEC ', and the index guideline needs to be changed to refer to the exposed name, as shown below.
因此索引加快了检索过程的速度,但减慢了修改的速度。
So, indexes speed the process of retrieval but slow down modification.
应用程序准备(编译)好一条语句之后,可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
另一方面,数据库是一个容 易做一些简单改变(添加一个索引,稍稍修改一个查询)并看到巨大性能改善的地方。
The database, on the other hand, is an easy place to make a few simple changes (add an index, change a query slightly) and see tremendous performance improvements.
下一个示例演示了如何不仅为表数据,还为索引和lob修改表空间。
The next example demonstrates how to alter the tablespace not only for table data, but also for indexes and LOBs.
另外,在查询重写状态下,修改SELECT来摆脱一个范围型谓词,可以通过提高索引键列匹配增强性能。
Also in the query rewrite vein, modifying a SELECT to get rid of a range-type predicate can increase performance by improving index key column matching.
如果创建新的索引,而在最后一次执行RUNSTATS以后还未修改相应的表,那么您可以只收集索引上的目录统计信息。
If new indexes have been created, and the corresponding table has not been modified since the last RUNSTATS execution, then you can collect catalog statistics on indexes only.
目录中不会反映这些修改,除非在这些表和索引上执行RUNSTATS。
None of these changes are reflected in the catalog, unless RUNSTATS is performed on these tables and indexes.
在创建索引期间,模型文件作为参数传递,而且只在此期间被读取;以后的修改不影响现有的索引。
The model file is passed as a parameter during index creation and is only read during index creation; later changes do not affect existing indexes.
该表属性用于针对特定表及其索引设置修改阈值。
The table property is used to set the change threshold for that specific table and its indexes.
初始更新之后是增量更新,那些已经被索引且没有被修改的对象不会被再次索引。
Updates after the initial update are incremental, unchanged objects that have already been indexed will not be indexed again.
SIAPI为只读的,不含有任何添加、删除或修改搜索索引的方法。
The SIAPI is read-only and does not contain any methods for adding, removing, or changing the search index.
它能让您将各种限制应用到索引advisor工具,并看看这些限制条件如何修改建议。
It allows you to apply various constraints to the index advisor and see how those constraints modify the recommendations.
尤其是有一两千万行数据的时候,每次修改模式、往数据库中添加索引都会数小时完全锁定数据库。
In particular, making schema changes or adding indexes to a database with more than 10-20 million rows completely locks the database for hours at a time.
在updatestatistics期间,数据修改小于所设置的STATCHANGE的表和索引将被直接跳过。
Tables and indexes with changes less than the imposed STATCHANGE are completely skipped during update statistics.
Solr将动态创建索引,在记录被创建、修改或删除时立即更新每个索引。
Solr creates the indices on the fly, updating each index immediately as records are created, modified, or deleted.
创建、浏览以及修改对象(表、视图、索引等),这其中包括Oracle8 TYPE对象。
Create, browse, or alter objects (tables, views, indexes, etc.) including Oracle8 TYPE objects.
如果你删掉了一个页面或者网站的部分内容,你可以通过修改robot. txt预防蜘蛛爬行和索引那些无效链接。
If you've removed a page or section, you can use the robot.txt to prevent the spiders crawling and indexing the broken links.
由于一些内部修改,导致应用需要重新创建索引(reindex),但总体来说,升级过程相当简单。
A reindex is also needed due to internal changes, but overall the upgrade process should be fairly simple.
对于不是在内部用压缩特性创建的索引,可以通过修改它们将它们转换成压缩索引。
For indexes that were not created initially with compression, you can turn them to compression by altering them.
开发一个服务器附件,自动将新的和修改了的文档从源数据库添加到索引数据库。
Develop a server add-on that automatically adds new and modified documents from the source database to the index database.
可以添加和删除索引;通过删除、改名或添加列来修改表;甚至在必要的时候借助于SQL。
You can add and drop indexes; alter tables by dropping, renaming, or adding columns; and even drop down into SQL as necessary.
更新处理过程会确定系统上的哪些对象是新添加的对象或是已经被修改了,然后索引那些对象的文本数据。
The update processing will determine which objects are new or changed on the system and index the text data for those objects.
第一个可能的未来改变是对未应答的包列表进行修改,因此包列表的组织形式不再是当前的线性列表而是通过索引组织成红-黑树。
The first potential future change would modify the unacknowledged packet list so that it is organized with an index as a red-black tree instead of the current linear list.
应用推荐