Question : I want to improve the performance of an SQL statement. I am on version 13. Here are the […]
Tag: performance-tuning
Optimizing intersect query in MySQL
Question : I’m facing a performances problem in our MariaDB server. We have a table linking users to pages, a […]
How Selective Should Index Be
Question : Is there a general Selectivity rule of when to apply Nonclustered index? We know not to create an […]
SQL Query, how to know if is resource intensive? I/O
Question : I am not a SQL guru, but I am troubleshooting an issue with our marketing platform as its […]
change optimizer’s plan on using indexes
Question : When I run a query as follows, the run time is less than 1 sec. SELECT @tenor_from =CONVERT(DATETIME,MIN(spc.maturity_date),103) […]
Changed limits: max_connections: 214
Question : I am using MySQL version 5.7.15 , ubuntu0.16.04.1. When I start the MySQL, I am getting below log, […]
Index columns on pre-production?
Question : If I understand correctly, indexing a column will increase SELECT speed but decrease INSERT speed. Say your app […]
Where can I find guidelines for building a SQL Server machine specifically for DBCC CHECKDB work?
Question : I’m working on defining specs for a new server to run DBCC CHECKDB scans on all databases in […]
Can indexes really decrease performances in a low volume writes DB? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Can performance be improved by breaking databases up? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]