Systematic index design consists of two processes

如此相信發表於2022-03-09
Index

Systematic index design consists of two processes

1. Detect SELECT statements that are too slow due to inadequate indexing
       Worst input: Variable values leading to the longest elapsed time
2. Design indexes that make all SELECT statements fast enough.
     Table maintenance (INSERT, UPDATE,DELETE) must be fast enough as well


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/70014873/viewspace-2868092/，如需轉載，請註明出處，否則將追究法律責任。

相關文章