Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Tag: performance
MySQL 2 Million Rows, longtext and varchar indexes
Question : I’m trying to find a solution for this, with no success. I have a table with ~2M rows, […]
Good, Bad or Indifferent: WHERE 1=1
Question : Given this question on reddit, I cleaned up the query to point out where the issue was in […]
Need some support on MySQL Query
Question : I have a query SELECT leads.id, sfav.id is_favorite FROM leads INNER JOIN teams tst ON tst.team_set_id = leads.team_set_id […]
Recommended Postgresql index type to be used with not equal (<>) where condition
Question : I need to query two huge tables (more than milion records). Besides other conditions, there is also a […]
Configuring PostgreSQL for write performance
Question : One of my PostgreSQL servers hosts several (1-3) databases which receive a constant stream of data. The data […]
Are unstructured databases faster using arrays or many binary variables? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Oracle’s Merge v. Select->Update/Insert
Question : What is the faster statement? A MERGE or Select->Update/Insert depending on if it returns a value? I’m trying […]
What can I add to a server to make SQL restores faster?
Question : I have a 2.8TB SQL database (mostly data files, some 400GB of log files) that currently takes around […]
When to Disable and Recreate Indexes in Data Warehouse ETL?
Question : We are moving data from Staging Database into Kimball Data Warehouse DB. I am hearing different ideas regarding […]