How to read T-SQL time statistics?
Parse and compile is the time it takes to validate syntax and object validity, then compile an execution plan. Elapsed time is how long it takes the query to execute and finish returning rows to the client (SSMS). If you're returning a lot of rows, the query itself may be done long before rows are done rendering in SSMS.