Oracle中的covering index
CSDN里的一个朋友问到了这个索引覆盖的概念。 这个概念很小的知识点，在我的论坛里有解释“”，不过作为Oracle版主，不能在回帖里加上网外的地址链接，所以这里在CSDN里帖上一份
比如有复合索引为3个字段：f1 + f2 + f3,请问:
1: select f1, f2, f3, f4 from table where f1 = 'XX' and f2 = 'XX'.
2: select f1, f2, f3 from table where f1 = 'XX' and f2 = 'XX'.
有人说1符合索引覆盖, 有人说只有2才符合, 请问哪个对?
Oracle中的covering index(应该翻译成覆盖索引)是指
http://www.inthirties.com/thread-458-2-1.html
# A covering index is an index, which includes all of the columns referenced in the query. So the creating covering index can improve performance because all the data for the query is contained within the index itself and only the index pages, not the data pages, will be used to retrieve the data. Covering indexes can bring a lot of performance to a query, because it can save a huge amount of I/O operations.
从这个定义上讲，2符合，1不符合。
相关文档：
create table emp2_log(
uname varchar2(20),
action varchar(10),
atime date
);
create or replace trigger trig
after insert or delete or update on emp2 for each row //绑在一张表上,before after 都可
以,before是 插数据之前，after是之后
begin
&nb ......
When queried, virtual columns appear to be normal table columns, but
their values are derived rather than being stored on disc. The syntax
for defining a virtual column is listed below.
column_name [datatype] [GENERATED ALWAYS] AS (expression) [VIRTUAL]
If the datatype is omitted, it is determin ......
ORACLE sql 的处理过程大致如下：
1.运用HASH算法，得到一个HASH值，这个值可以通过V$SQLAREA.HASH_VALUE 查看
2.到shared pool 中的 library cache 中查找是否有相同的HASH值，如果存在，则无需硬解析，进行软解析
3.如果shared pool不存在此HASH值，则进行语法检查，查看是否有语法错误
&nbs ......
上節學習開第一個Form，這個節在添加一個彈出下拉框
第一步：添加記錄組
1.1 選中Record Groups
1.2 單擊Create
1.3 輸入查詢SQL
1.4 單擊OK
1.5 修改 ......
