MemSQL Development   Query Tuning


Topic Replies Activity
Function in filters evaluated multiple times 4 March 26, 2020
Insert Linestring geospatial 5 March 25, 2020
Upgraded to 7.0 - AutoStat value missing 6 March 5, 2020
Slow HashGroupBy in columnstore table 7 February 21, 2020
What's the most efficient way to delete millions of rows in MemSQL? 11 February 20, 2020
MemSQL 7.0 SingleStore issues 10 February 14, 2020
Unexpected detrimental index usage 6 February 10, 2020
Is it recommended to schedule ANALYZE queries on all tables? 8 February 3, 2020
Query with LEFT OUTER JOIN returns bad performance result 3 January 23, 2020
Show slow performance response using order by 29 January 20, 2020
ANALYZE TABLE command slowed the query performance 2 January 15, 2020
Unsupported nested scalar subselects 2 January 10, 2020
What is best practice for CLUSTERED COLUMNSTORE keys 12 January 3, 2020
Unexpected query performance degradation 9 October 9, 2019
Benchmark: Filter on integers is significant faster than small varchars on rowstore but not on columnstore 5 September 30, 2019
Problem with 'maximum_memory' reached in query 5 August 23, 2019
Running parallel queries in columnsore 4 August 19, 2019
Maximum Index Width 2 August 7, 2019
How to optimize a query with JOINs and ORDER BY? 9 July 29, 2019
Slow log configuration 2 July 19, 2019
Does order of index matter? 2 July 11, 2019
HLL + Group By - Memory Usage 5 May 24, 2019
The operating system failed to allocate memory 2 April 23, 2019
Delete with join performance 8 February 22, 2019
MEMSQL returing undefined results 3 January 29, 2019
Decimal data type in columnstore table 4 December 19, 2018
OrderedColumnStoreScan segment scanning with CTEs 7 December 19, 2018
Poor query plan based on values 9 December 6, 2018
"1 warning" but nothing in output 4 December 4, 2018
Query plan optimization for columnstore filters 5 December 3, 2018