因此索引加快了检索过程的速度，但减慢了修改的速度。
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.
修改影响：DB 2将自动维护您创建的每个索引。
Modification impact: DB2 will automatically maintain every index you create.
另一方面，数据库是一个容 易做一些简单改变（添加一个索引，稍稍修改一个查询）并看到巨大性能改善的地方。
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.
以其他方式修改数据库，包括添加、删除或修改索引或其他约束。
Changing the database in other ways, including adding, dropping, or modifying indexes or other constraints.
如果创建新的索引，而在最后一次执行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.
此外，在DB 2中，一旦创建了索引，就不能修改索引定义中的任何子句。
Also, once an index has been created in DB2, you cannot alter any clause of the index definition.
该表属性用于针对特定表及其索引设置修改阈值。
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.
公开的表名为“SEC”，并且需要修改索引准则，使其引用这个公开的表名，如下所示。
The exposed table name is' SEC ', and the index guideline needs to be changed to refer to the exposed name, as shown below.
创建、浏览以及修改对象(表、视图、索引等)，这其中包括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.
在创建了一个新的存档文件，或者修改了一个现有的存档文件之后，需要创建存档文件内容的索引，并将其作为该存档文件的一部分进行存储。
After a new archive is created or an existing one is modified, an index of archive contents needs to be created and stored as part of the archive.
由于每个索引(片段)都有自己的udi计数器，因此将根据索引(片段)的修改程度判断是否跳过或是重建索引统计。
Since each index (fragment) has its own UDI counter, the decision to skip or rebuild index statistics is done based on how much the index (fragment) has changed.
然而在过去一年，我们发现一些大型的公司创建或修改在线内容，目的单纯是为了搜索引擎优化（SEO）。实际上，这意味着这些内容对用户本身并不那么有用了。
However, in the past year we’ve seen some major businesses create or change content to drive pure SEO benefit which actually means the content isn’t as beneficial to users themselves.
应用推荐