- 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
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
-
The Google Adsense made a blog post with a video to help us understand the concept behind eCPM (Effective Cost Per Thousand Impressions). ...
-
An efficient method to find out the total record counts of all tables in an Oracle database. select table_name, to_number(extractvalue(xm...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.