索引如何帮助在mysql中快速搜索数据

时间:2023-01-15 00:12:01

I am using MYISAM engine for save data in MYSQL. My data base have some tables with 50 thousand records. We are using index with our tables, I want to know ...

我使用MYISAM引擎在MYSQL中保存数据。我的数据库有一些表有5万条记录。我们在桌子上使用索引,我想知道......

  • How index make data search fast. What logic or ALGO is using by mysql behind indexing.
  • 索引如何快速进行数据搜索。索引后的mysql使用了什么逻辑或ALGO。

1 个解决方案

#1


1  

I hope this article will helpful for you

我希望这篇文章对你有所帮助

http://guptavikas.wordpress.com/2012/12/17/b-tree-index-in-mysql/

http://guptavikas.wordpress.com/2012/12/17/b-tree-index-in-mysql/

#1


1  

I hope this article will helpful for you

我希望这篇文章对你有所帮助

http://guptavikas.wordpress.com/2012/12/17/b-tree-index-in-mysql/

http://guptavikas.wordpress.com/2012/12/17/b-tree-index-in-mysql/