I'd like to know how many rows may have the data extension susceptible of being treated by a SQL.
I have 20 million records in my Data extension, so I would like to know how many rows can I assume in my query.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
SQL queries in Marketing Cloud are bound to what can be run in 30 minutes. So to answer your question, the while the number of rows might be a factor (i.e too many rows) other factors include:
In general, try to keep the above factors to a minimum of you have to. In your use case, I doubt you are in the position to reduce the number of columns. So I would limit the use of joins, querying data tables and make my queries sargable.