Author Archives: user

MySQL – WHERE Clause Table of content MySQL WHERE Clause We know that the SQL SELECT command is used to fetch records from a MySQL table. In addition to that, we can also use a conditional clause called the WHERE Clause in conjunction with the SELECT statement to filter out the results. Using this WHERE […]

MySQL – Non-Clustered Index Table of content Indexes in MySQL are used to retrieve the data much faster from the database tables or views. Users cannot see the indexes on the application level, but they work behind to speed up searches and queries. There are two types of Indexes in MySQL − Clustered Index Non-Clustered […]

MySQL – Clustered Index Indexes in MySQL are used to retrieve the data much faster from the database. We (users) cannot see the indexes, but they work behind to speed up searches and queries. They are categorized into two types: clustered and non-clustered indexes. A clustered index can sort the data in a table manually. […]