2:InnoDB的非主键索引(Secondary Index)是普通的B-Tree索引. mysql性能优化-慢查询分析、优化索引和配置 - - 数据库 - ITeye博客 profiling分析查询.
基于26个网页-相关网页
And the non-primary index is used more frequently and designed more complicatedly than the primary index.
而非主键索引是一个比主键索引使用频率更高、设计更为复杂的索引机制。
参考来源 - 嵌入式主动实时数据库ARTs·2,447,543篇论文数据,部分数据来源于NoteExpress
系统依据属性的类型决定是否要基于此属性创建非主键索引、是否要保存此非主键索引。
The system determines whether it needs establishing and reserving the non-primary index by the classification of the attribute.
在分析了用于查找内存数据的非主键索引的特性之后,设计并实现了一个适合于内存数据库的非主键索引机制。
After analyzing the characteristics of the non-primary index used to search the data in the main memory, a new non-primary index system is designed and implemented which fits to MMDB.
应用推荐