Category: DATABASE

You will find tutorials for MySQL DB, DB2, Oracle, InfluxDB, and MongoDB

How to use indexes to get better performance – MySQL

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. Indexes use extra space...

Explain Keyword and SQL Execution Plan in MySQL

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 details of your tables,...

Introduction to Indexes in database

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 searches/queries. Q: How indexes...

Get Indexes in SQL Server

Get Indexes in SQL Server

Use below query to get Indexes in the SQL Server SELECT ind.name ,ind.index_id ,ic.index_column_id ,col.name ,t.name FROM sys.indexes ind INNER JOIN sys.index_columns ic ON ind.object_id = ic.object_id and ind.index_id = ic.index_id INNER JOIN sys.columns...

How to remove phpmyadmin permission to access the mysql database?

How to remove phpmyadmin permission to access the mysql database?

Output: Forbidden You don’t have permission to access / on this server. TO RESOLVE THE ABOVE ERROR WE NEED TO MAKE THE FOLLOWING CHANGES IN phpmyadmin.conf FILE LOCATED AT c:\wamp\alias\phpmyadmin.conf Options Indexes FollowSymLinks MultiViews...