Question : I’m currently running into an issue with one of our databases in Azure where 1 table is forcing […]
Tag: query-performance
Searching against a large list of people at the same time in Postgres
Question : I have a list of people that varies between 2-5k entries that has this general format: firstname1 lastname1, […]
Get the id_user_app if not exists in id_user_rq
Question : I’m building a application and have this table for users relationships. I need to build some queries like […]
How do I find the least optimised query?
Question : A library uses a relational database to store data about library books, their members and lending (books, which […]
MY Sql group by taking too much time [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
How to make MySQL query performant WHERE one column uses greater than and one column uses less than?
Question : I’d like to make this query perfomant– SELECT * FROM my_table WHERE foo_id = 8 AND enabled = […]
mysql query takes too long for a million row table using count() and group by
Question : I want to retrieve phone_num and their count of unread message for each phone number from the table […]
Tuning a query to fetch all the records in a day with certain status
Question : We are currently using Oracle Database: Consider a table TRANSACTION with the fields TRAN_ID, STATUS, CREATED_TIME, …. The […]
Unable to understand correlation between MaxWorkers created and CPU utilization
Question : I am having a strange issue which i am unable to understand: On my server with 64 Logical […]
T-SQL Query or DB Engine Optimization? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]