| 1. | The secondary indexes are partitioned just like the primary xml index 辅助索引的分区方式类似于主xml索引。 |
| 2. | A primary xml index must first exist before you can create secondary indexes 有了主xml索引才能创建辅助索引。 |
| 3. | These are the types 辅助索引的类型如下: |
| 4. | Type columns , a path secondary index may be able to speed up the search 类型列指定路径表达式,则path辅助索引可以提高搜索的速度。 |
| 5. | If you drop the primary xml index , any secondary indexes that are present are also deleted 如果删除主xml索引,则会删除任何现有的辅助索引。 |
| 6. | If you add a path secondary index , you may also improve the search performance in such queries 如果添加path辅助索引,则您还可以提高此类查询的搜索性能。 |
| 7. | Depending on the type of queries , these secondary indexes might help improve query performance 根据查询类型的不同,这些辅助索引可能有助于改善查询性能。 |
| 8. | For a secondary index on an index - organized table , the percentage of rows with valid guess 对于通过索引组织的表上的辅助索引,为具有valid猜测的行的百分比。 |
| 9. | Queries that retrieve one or more values from individual xml instances might benefit from a property index Property辅助索引从单个xml实例检索值的查询适用property索引。 |
| 10. | Drop existing can drop a secondary index on the user table and create another secondary index on the user table Drop _ existing可以删除用户表的辅助索引并为用户表创建其他辅助索引。 |