SQL> create table test(object_id NUMBER,object_name varchar2(10));
Table created.
SQL> begin
2 for i in 1 .. 1000000
3 loop
4 insert into test values (1,'TEST');
5 end loop;
6 end;
7 /
PL/SQL procedure successfully completed.
SQL> begin
2 for i in 1 .. 300
3 loop
4 insert into test values (2,'TEST2');
5 end loop;
6 end;
7 /
PL/SQL procedure successfully completed.
SQL> begin
2 for i in 1 .. 49700
3 loop
4 insert into test values (2,i||'TEST2');
5 end loop;
6 end;
7 /
SQL> select count(*), object_id from test group by object_id;
COUNT(*) OBJECT_ID
---------- ----------
1000000 1
50000 2
SQL>
组合索引和单列索引效率对比
最新推荐文章于 2022-12-22 13:48:18 发布
本文探讨了数据库中的组合索引与单列索引在查询效率上的差异,通过实例分析揭示了在不同场景下如何选择合适的索引类型以优化查询性能。对于大数据量的表,合理使用索引能显著提升查询速度。
摘要由CSDN通过智能技术生成