#007FFF

"Sir, I have learnt to stand up on my feet after having broken both my legs. This attitude has come with great difficulty. No sir, I can't. You may keep your job, and let me keep my attitude." by 3 idiots

部落格全站分類：職場甘苦

其實我不太確定這是By-design 還是Product limit 還是環境因素
原因是資料儲存在Disk上，第一次讀時會需要時間把資料從Disk Load到Memory裡
cache之後執行速度就會變快。

我後來是加了 execution plan 來定期更新 statistic，這問題就不會影響到Production

my007FFF

#007FFF

my007FFF 發表在痞客邦留言(0) 人氣()

E-mail轉寄