面试回来发考题3 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

面试回来发考题3

面试回来发考题3# Database - 数据库

n*62008-12-03 08:12

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*g2008-12-03 08:12

2 楼

见baozi就上。
indexes usage
accesse path
join type and order
execution flow
cost and cardinality

n*62008-12-03 08:12

3 楼

Be more specific. ;)

【在 B*****g 的大作中提到】

: 见baozi就上。
: indexes usage
: accesse path
: join type and order
: execution flow
: cost and cardinality

j*n2008-12-03 08:12

4 楼

Usually I look for scans and red color (missing stats)

j*n2008-12-03 08:12

5 楼

so,have you got the offer?

B*g2008-12-03 08:12

6 楼

ding

【在 j*****n 的大作中提到】

: so,have you got the offer?

n*62008-12-03 08:12

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 的大作中提到】

: so,have you got the offer?

j*n2008-12-03 08:12

8 楼

well, hope the best.
btw, where is the position again? IL?

and

【在 n********6 的大作中提到】

: 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.)