|
Any Query to find the complete SQL query that is in sleep for more than 60?
|
|
3
|
966
|
May 11, 2022
|
|
10mi rows with 5 self join takes 57s in free trial license
|
|
10
|
1283
|
May 10, 2022
|
|
Query Performance Issue
|
|
14
|
1221
|
April 28, 2022
|
|
Unsupported nested scalar subselects
|
|
8
|
2732
|
April 11, 2022
|
|
What is the most efficient way to drop 200+ tables except for a few tables in a given DB?
|
|
1
|
1091
|
March 3, 2022
|
|
Queing of queries - How to makeout the reason
|
|
2
|
1205
|
February 17, 2022
|
|
Regular expression REGEXP_REPLACE not supporting POSIX ERE
|
|
1
|
1184
|
February 5, 2022
|
|
Sort Key - How to check whether segment getting eliminated or not
|
|
2
|
1318
|
December 4, 2021
|
|
Query Tuning Fix Broadcast Operation
|
|
6
|
1517
|
August 24, 2021
|
|
Error on complex generated queries
|
|
2
|
1409
|
October 7, 2021
|
|
Redundant index
|
|
1
|
1392
|
October 6, 2021
|
|
Performance of retrieving rows
|
|
1
|
1420
|
October 5, 2021
|
|
Slow HashGroupBy in columnstore table
|
|
8
|
3117
|
September 16, 2021
|
|
Performance of querys joining on VARCHARs of different lengths
|
|
3
|
1759
|
May 19, 2021
|
|
Full join query not utilizing index
|
|
1
|
1558
|
June 17, 2021
|
|
Query not utilizing columnstore shard key
|
|
1
|
1670
|
June 11, 2021
|
|
Performance of queries with using view
|
|
1
|
1616
|
June 10, 2021
|
|
Performance issue for select stmt
|
|
1
|
1572
|
April 28, 2021
|
|
SELECTS per second per thread/core vs. MariaDB in Memory
|
|
1
|
1630
|
March 17, 2021
|
|
First query is slow. 2nd one is fast. why?
|
|
7
|
2237
|
December 21, 2020
|
|
Hash join takes too long
|
|
1
|
1799
|
December 2, 2020
|
|
Choosing Columnstore Key for Time-series data
|
|
1
|
2107
|
October 7, 2020
|
|
Replicating one table's data to another after some processing on each row
|
|
4
|
2212
|
September 24, 2020
|
|
Optimizing Performance of "ORDER BY 'X' DESC" on Large Tables
|
|
5
|
2060
|
September 1, 2020
|
|
Memsql 7.1.5 TO_JSON() is not honoring Limit Clause
|
|
1
|
1998
|
August 11, 2020
|
|
Columnstore segments scanning optimization
|
|
1
|
2200
|
June 27, 2020
|
|
Creating shard key /CLUSTERED COLUMNSTORE index on persisted columns
|
|
1
|
2427
|
April 29, 2020
|
|
Query which needs more resources
|
|
0
|
2185
|
April 23, 2020
|
|
Function in filters evaluated multiple times
|
|
3
|
2394
|
March 26, 2020
|
|
Insert Linestring geospatial
|
|
4
|
2293
|
March 25, 2020
|