- Parse - parsing whole statement whether it has mistake in it or not.
- Resolve - getting info about tables,views so on.
- Optimize - deciding how to execute the query more efficiently
- Compile - creating executing plan about whole process
- Execution - final point to realize the execution plan
All implemented execution plans are stored in Plan Cache, to prevent next queries' execution plans to reduce the performance by reading related plans throughout disc.