This message was deleted.
# generals
Slackbot
10/30/2023, 3:33 PMThis message was deleted.
l
Laksh Singla
10/30/2023, 3:38 PMI am not completely sure, but afaik MSQ can’t plan righty joins. Can you post the sql plans for both the engines. Also, for a simple select, MSQ is bound to be slower because MSQ launches tasks, reads segments and then performs the queries.
b
Ben Krug
10/31/2023, 1:35 AMIs it MSQ? The SQL and the explain output would help, to give a +1 to what Laksh said.
a
Anshu Makkar
11/01/2023, 4:59 AMI did explain on sql Query and the json query I.e plan output I used to do json query answered in less than a second
b
Ben Krug
11/02/2023, 8:38 PMWhat is the SQL query? (Wild stab, does it have a long IN list?) If you post the query, that would help.
a
Anshu Makkar
11/03/2023, 10:53 AMYes it has
Anshu Makkar
11/03/2023, 10:53 AMI will get the query from the team
b
Ben Krug
11/03/2023, 7:31 PMI had a hunch, sounded like the planning step (SQL -> native) takes a long time. You can try setting
"inSubQueryThreshold": 0"