Обсуждение: Question regarding SQL-query minimizer

Поиск
Список
Период
Сортировка

Question regarding SQL-query minimizer

От
Jinho Jung
Дата:

Hello, I am Jinho. Yesterday, I found one interesting SQL statement that actual query execution time took much longer than expected. I also check the result is wrong from EXPLAIN ANALYZE. 

Current problem is the length of SQL (14KB) when I try to analyze the root cause. If you want to remove unnecessary part (i.e., minimize the size of SQL unless it contains same problem), do you use any tool?

Thanks,
Jinho Jung