- Operators – introduced in the last article, now you'll see more
- Joins – what's a relational system without the joins between tables
- WHERE clause – you need to filter your data and it does affect the execution plans
- Aggregates – how grouping data changes execution plans
- Insert, Update and Delete execution plans
Friday, December 19, 2008
Graphical Execution Plans for Simple SQL Queries
The aim of the article is to enable you to interpret basic graphical execution plans, in other words, execution plans for simple SELECT, UPDATE, INSERT or DELETE queries, with only a few joins and no advanced functions or hints. In order to do this, we'll cover the following graphical execution plan topics:
Subscribe to:
Post Comments (Atom)
Popular Posts
-
新加坡人口400万，亚洲人口4亿，全世界人口6亿。 但是，我一人可能就很有可能是世界最傻的了。我真是个不折不扣的大木头。真是受不了自己。
-
I was at Bugis Junction today and saw 蘇打綠 (Soda Green) performing. They look so much different especially the lead singer. I find their song...
-
Pledge to finish my 1st task after my 2 full days of rest by today. 03 March 2010 : CS4236 Project deadline It is basically a "waste-t...
-
Despite the implementation of a mandatory plastic bag charge in local supermarkets in July 2023, recent data reveals that consumers still pu...
-
I recently wrote a code snippet to fill arrays with a value. The below method is a generic method that will accept different data types. Hop...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.