OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

How to classify whether the SQL statement is complex or not in a SQL file which contains more than1000 lines of query? [closed]

  • Thread starter Thread starter Nagul Pranav V S
  • Start date Start date
N

Nagul Pranav V S

Guest
I need to find the complex SQL statement based on the best practices of Bigquery inside a large SQL file which contains more than 1000 lines of query. How can I do this?

I tried REGEX to find the pattern of JOINS, Sub Queries, Unions etc. But in a single line statement, a single JOIN wont be considered as a complex thing. So how can I find whether the Join in a statement is will lead to a complex computation or not?
<p>I need to find the complex SQL statement based on the best practices of Bigquery inside a large SQL file which contains more than 1000 lines of query. How can I do this?</p>
<p>I tried REGEX to find the pattern of JOINS, Sub Queries, Unions etc. But in a single line statement, a single JOIN wont be considered as a complex thing. So how can I find whether the Join in a statement is will lead to a complex computation or not?</p>
Continue reading...
 
Top