带您了解Oracle FBI索引
作者:系统运维 来源:人工智能 浏览: 【大中小】 发布时间:2025-11-04 00:27:30 评论数:
复制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.