n********6 发帖数: 1511 | 1 What do you see in the execution plan (to do performance tuning)?
(Using Google is not allowed in answering this question. Baozi will be
available for any good answers if applicable.) |
B*****g 发帖数: 34098 | 2 见baozi就上。
indexes usage
accesse path
join type and order
execution flow
cost and cardinality |
n********6 发帖数: 1511 | 3 Be more specific. ;)
【在 B*****g 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 见baozi就上。 : indexes usage : accesse path : join type and order : execution flow : cost and cardinality
|
j*****n 发帖数: 1781 | 4 Usually I look for scans and red color (missing stats) |
j*****n 发帖数: 1781 | 5 so,have you got the offer? |
B*****g 发帖数: 34098 | 6 ding
【在 j*****n 的大作中提到】![](/moin_static193/solenoid/img/up.png) : so,have you got the offer?
|
n********6 发帖数: 1511 | 7 They are interviewing other candidates.
I got an impression from them that they are satisfied with my knowledge and
skills.
A couple of mistakes I made:
- Did not come up with the term, recursive function, in the first minute.
- Did not explain the IN and Exists well. (It was the last question raised
by the DBA. He must think I could answer this question very well. I was a
little bit tired.)
【在 j*****n 的大作中提到】![](/moin_static193/solenoid/img/up.png) : so,have you got the offer?
|
j*****n 发帖数: 1781 | 8 well, hope the best.
btw, where is the position again? IL?
and
【在 n********6 的大作中提到】![](/moin_static193/solenoid/img/up.png) : They are interviewing other candidates. : I got an impression from them that they are satisfied with my knowledge and : skills. : A couple of mistakes I made: : - Did not come up with the term, recursive function, in the first minute. : - Did not explain the IN and Exists well. (It was the last question raised : by the DBA. He must think I could answer this question very well. I was a : little bit tired.)
|
a******8 发帖数: 46 | 9 search "t-sql execution plan" @ www.live.com |