There are queries where when we hit "execute", it shows some rows and it keeps growing, bu the query is not over yet. but sometimes, it waits until the end of the query.

Why does this happen? is there a way to control this?