SQL Shack

APRIL 13, 2020

This article explores SQL Server Update Statistics using the database maintenance plan. Introduction SQL Server query optimizer uses statistics to build an optimized execution plan.

Database 63

Database Servers Performance 63

Percona

JANUARY 5, 2023

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. It involves removing deleted or outdated rows from tables and indexes and updating statistics used by the query planner. When a row is updated or deleted, it is not immediately removed from the table.

Database 106

Database Performance C++ Efficiency 106

Percona

FEBRUARY 24, 2023

If you’re using PostgreSQL in the cloud, there’s a good chance you’re spending more than you need in order to get the results you need for your business. Usage reduction: What to look for to reduce PostgreSQL cloud costs The first step in cost reduction is to use what you need and not more. Don’t pay for capacity you don’t use or need.

Cloud 118

Cloud Serverless AWS Storage 118

SQL Performance

OCTOBER 26, 2021

The SQL Server query optimizer makes use of statistics during query compilation to help determine the optimal query plan. The Problem With Synchronous Statistics Updates. How many statistics for each of those tables have to be updated because they’re needed for compilation. Introduction.

Servers 55

Servers Metrics Database Performance 55

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Depending on the version of MySQL you are running , some of the default values used in this post may differ from your install, but the premise is still largely the same. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. Statistics. Index maintenance. SQL Server Agent alerts.

Servers 49

Servers Azure Hardware Database 49

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Using partitioning in a MySQL 5.7 So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40