带您了解Oracle FBI索引

发表于 2025-11-05 03:46:36 来源：全栈开发

复制SQL>create index non_fbi on sale_contacts (surname); SQL>analyze index non_fbi compute statistics; SQL>:analyze table sale_contacts compute statistics; SQL>SELECT count(*) FROM sale_contacts WHERE UPPER(surname) = ELLISON; Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3Card=1Bytes=17) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF SALES_CONTACTS (Cost=3Card=16Bytes=272) 1.2.3.4.5.6.7.8.9.10.11.

喜欢84讨厌68

随机为您推荐

热门文章

文章排行