Question : I have a TEXT keyvalues column in Postgres: select * from test5 limit 5; id | keyvalues —-+—————————————————— […]
Category: Query Performance
What are some efficient ways in using COUNT(*) with WHERE
Question : Instead of calling COUNT(*) with a WHERE clause, is there anything one can do to make this work […]
Can you gain the performance benefits of partition elimination without changing SQL module or table definitions?
Question : I work for a company that has a multi-tenant database model that doesn’t currently use database partitioning. The […]
Can I speed up this slow query which should be limited by MIN/MAX values?
Question : The intention here is to look at the user retention over a period of time. My current solution […]
Unable to Query Very Large Table
Question : I have a table defined as: CREATE TABLE [dbo].[DataTable]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [Data] [varbinary](max) NULL, [Preview] […]
Slow MySQL query
Question : I have 3 tables: Name Engine Rows Data Size Index Size Total Size product MyISAM 11.06M 859.59M 861.20M […]
Query execution time is random, need to identify the root cause
Question : I have a query like below select * from table1 where column2=123 and column3=’B’ Now the issue faced […]
SQL Server WHERE clause on CLR method (spatial) peformance
Question : I have a query that joins to a table containing 2 million rows and need to filter on […]
Get data faster from databasse
Question : My site having a more than 1.5 million records and my question is the how may i fetch […]
Query optimizer recommends adding index instead of using existing index
Question : I am trying to determine why the query optimizer in SQL Server is recommending creating a new index […]