Category: ADVANCE

How to use indexes to get better performance – MySQL 0

How to use indexes to get better performance – MySQL

It is very important to have a close look on the indexes because inappropriate use of indexes may lead to performance degradation. Here are some points that tells how: 1....

Explain Keyword and SQL Execution Plan in MySQL 0

Explain Keyword and SQL Execution Plan in MySQL

SQL Execution Plan: You can see the SQL Execution Plan by using “Explain” keyword. It tells how query is executed. Understanding the Query Execution Plan in MySQL Depending on the...

Introduction to Indexes in database 0

Introduction to Indexes in database

Q: What are indexes? Indexes are the special tables in the database that makes the search faster. The users cannot see the indexes, they are just used to speed up...

Trigger in MySQL 0

Trigger in MySQL

In this post we will see how to use Trigger in MySQL. What is a Trigger: A SQL trigger is a set of SQL statements stored in the database catalog....