There have always been numerous discussions about SQL performance and optimization in the field of database management. Thatโs because it is an incredibly complicated task, especially when it comes to large-scale data where the slightest variation can bring drastic changes to the entire databas...
Like everything else, indexes also come with a few shortcomings of their own. However, this post will focus on query optimization while considering both situations - those that contain table indexes and those without. An indication of good MySQL SQL performance tuning is the inclusion of detail...
As time passes, human resources are rapidly getting replaced by computing resources, affecting the task range of an Oracle DBA. You may have...
Ask anyone involved in administering and handling relational databases about the most time consuming tasks: the most common answer is likely to be coding and tuning SQL. The simple reason behind this is the presence of thousands of separate SQL queries spread throughout numerous applications that repeatedly access your multiple production databases. So, even thoughโฆ
In this blog, we'll cover redundant and duplicate indexes, which are quite common in applications and affect database performance. An index is duplicated when there is more than one defined on a single column. Such indexes may have varying names or keywords...
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it's the time dimension that isn't additive. For example, the stock level at various warehouses. You can add all the stock levels of your
A detailed SQL cheat sheet with essential references for keywords, data types, operators, functions, indexes, keys, and lots more. For beginners and beyond.
This SQL cheat sheet covers SQL commands and queries along with their implementation. Download SQL command PDF and learn SQL offline easily.
This SQL cheat sheet covers SQL commands and queries along with their implementation. Download SQL command PDF and learn SQL offline easily.
Database Tuning refers to a group of activities used for homogenizing and optimizing the performance of a database. Usually, it protru...
There are many sites online that have SQL practice features and exercises. This list contains 17 different SQL practice sites for you to use.
There are many sites online that have SQL practice features and exercises. This list contains 17 different SQL practice sites for you to use.
This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
๐ฒ๐ฏ% ๐ผ๐ณ ๐ฑ๐ฒ๐๐ฒ๐น๐ผ๐ฝ๐ฒ๐ฟ๐ ๐ณ๐ฎ๐ถ๐น ๐๐ต๐ถ๐ ๐ฐ๐ต๐ฎ๐น๐น๐ฒ๐ป๐ด๐ฒ. A simple question ๐ Is the index below a good fit for the query? --- CREATEโฆ | 34 comments on LinkedIn
join in sql sql joins cheat sheet joining tables left join join combines data from two tables. left join returns all rows from the left table with matching rows
This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
We talked about InnoDB via several articles such as InnoDB vs Percona XtraDB, InnoDB Optimization etc. A practical question is, which is better MySQL engine for WordPress โ MyISAM or InnoDB? In the year 2014, we have written about MyISAM โ โMyISAM is ACID compliant. ACID stands for Atomicity, Consistency, Isolation, Durability. Most Plugins works โฆ
A clustering index is a different type of index that contains the entire data for the rows. Users gain quicker access to rows through cluste...
