Database Execution Plan and Database Indexing - Two things your mama probably didn't tell you
Truly, in life... There is no shortcut. And the same rule applies to me. I just came from a very exhausting interview today and I was asked about several things about Java technology tools which I don't have experience with and SQL Performance Tuning. The most frustrating question though was when I was asked about SQL. And what about SQL you might say? Listen to my story..
In a scale of 1-10, how would you rate yourself in SQL? I was confident enough that time to give myself an 8. I can write from simple SELECT, INSERT, UPDATE, DELETE to using JOINS, and perhaps some stored procedures, views and SQL scripts. I was asked about an Execution Plan. What the hell? Execution plan? I didn't know... Darn... My interviewer told me that if I gave myself an 8 then I should atleast know about this. I guess he was right, wasn't he? It was a good lesson for me not to be overconfident over simple stuff like SQL. There are indeed a lot of things that I still need to know. I was also asked about indexes which I already heard before but didn't do much reading upon. I wanted to tell him I wasn't applying for a database administrator position but I just kept my mouth shut to avoid any commotion. Lolz!
This is not the time to feel disappointed so I invite you to learn these things if you don't already know about these stuff yourself. Don't worry. We'll get better.
Some useful links
SQL Tuning Tutorial - Understanding a Database Execution Plan
You might also want to know that the standard chartered bank is a Bank and not a kind of Bank. Hahaha!