Debug SQL summary in SQL Maxcomputer

1. Segmented commissioning

The face of long SQL, error generally directly look at the location of the line number, sometimes not error but no data, you should try to segment debugging, very long SQL nested a lot of sub-queries, a sub-query to debug separately, see which step query out the problem, layers of promotion

2. Log View

In general, logs are important instructions. Sometimes some inexplicable error, when the error message can not be understood, you may want to try to view the running log (such as related settings, the system resolves the SQL to run)

Debug SQL summary in SQL Maxcomputer