Home  >  Article  >  Database  >  How to add index to table in navicat? (pictures and text)

How to add index to table in navicat? (pictures and text)

不言
不言forward
2018-09-29 17:41:0115421browse

The content of this article is about how navicat adds indexes to tables? (Pictures and text), it has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

Recommended related mysql video tutorials: "mysql tutorial"

navicat adds index to the table

Analyze common query scenarios and fields Add indexes to increase query speed.

You can add a single column index and a joint index.

How to add index to table in navicat? (pictures and text)

How to add index to table in navicat? (pictures and text)

How to add index to table in navicat? (pictures and text)

Right click, you can view and add modified indexes in the design table!

Indices must be added according to common query scenarios!

Write a sql statement and test it, and the index is indeed used!

You can determine what index is used by its name!

Help and follow-up helped me understand how to use indexes.

navicat software is still very good!

I like!

Let’s talk about optimizing queries. Every line of code can be optimized! Every query can be optimized! After writing the interface, you can check to see where the execution efficiency is low. If the data is small, it cannot be seen, but if the data is large, it will not be obvious. Bad design will show itself vividly!

The above is the detailed content of How to add index to table in navicat? (pictures and text). For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:cnblogs.com. If there is any infringement, please contact admin@php.cn delete