为前缀表如何服务于Flashback Data Archive(12)

3 - filter(("OPERATION"<>'D' OR "OPERATION" IS NULL) AND ("STARTSCN"<=12723380596675 OR "STARTSCN" IS NULL) AND
              "ENDSCN">12723380596675 AND "ENDSCN"<=12723381193707)
  4 - access("OBJECT_ID"=100)
  5 - filter("STARTSCN"<=12723380596675 OR "STARTSCN" IS NULL)
  8 - filter("T"."VERSIONS_STARTSCN" IS NULL)
  9 - access("T"."OBJECT_ID"=100)
  10 - access("RID"(+)=ROWIDTOCHAR("T".ROWID))
      filter("RID"(+)=ROWIDTOCHAR("T".ROWID))
  11 - filter(("ENDSCN"(+) IS NULL OR "ENDSCN"(+)>12723381193707) AND ("STARTSCN"(+) IS NULL OR
              "STARTSCN"(+)<12723381193707))

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/cdb7d569b9fe4ad8aa44d7184a208417.html