indexed plan 中文意思是什麼
indexed plan
解釋
標高平面-
In the previous example, if customer. customer num and orders. customer num are not indexed, dynamic hash join would be chosen by the optimizer as the best execution plan. the optimizer will choose nested - loop joins if
在前一個實例中,如果customer . customer _ num和orders . customer _ num都沒有被索引,那麼優化器將選擇動態哈希連接來作為最佳的執行計劃。 -
The indexed view is used by the query optimizer to produce the query plan
查詢優化器使用該索引視圖生成查詢計劃。
分享友人