Home > Database > Mysql Tutorial > body text

Summary of points to note about index merging

巴扎黑
Release: 2017-06-14 13:47:06
Original
1609 people have browsed it

Please indicate the source for reprinting: mysql index merging: one sql can use multiple indexes Preface MySQL's index merging is not a new feature. It has been implemented as early as mysql5.0 version. The reason why I still write this blog post is because many people still retain the misconception that a SQL statement can only use one index. This article will illustrate how to use index merging through some examples. What is index merging Let's take a look at the description of index merging in the mysql document: The Index Merge method is used to retrieve rows with several range scans and to merge their results 

1. mysql index merge: one SQL can use multiple indexes

Summary of points to note about index merging

##Introduction: MySQL's index merging is not a new feature. It has been implemented as early as mysql5.0 version. The reason why I still write this blog post is because many people still retain the misconception that a SQL statement can only use one index. This article will use some examples to illustrate how to use index merging

2. coreseek configuration and incremental index merging index

Introduction:: This article mainly introduces coreseek configuration and incremental index merge index. Students who are interested in PHP tutorials can refer to it.

3. [Practical] Sphinx index merging script

Introduction: mkdir /usr/local/sphinx/ scripts----0. Create all main indexes#!/bin/bash#ocpyang@126.com#main_index_update.sh/usr/local/sphinx/bin/indexer src2 -c /usr/local/sphinx/etc/sphinx .conf --rotate /dev/null 21/usr/local/sphinx/bin/indexer src3 -c /usr/loca

##[Related Q&A recommendations]:

The above is the detailed content of Summary of points to note about index merging. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!