Cost-based subquery correlation and decorrelation

Cost-based subquery correlation and decorrelation

Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Beavin, Thomas Abel, Cai, Mengchu, Chen, Yao-Ching Stephen, Cheng, Hsiuying Yen, Lin, Fen-Ling, Liu, Irene Ching-Hua, Mukai, Jerry, Ni, Demai, Tsuji, Yoichi, Xia, Li, Zeng, Ying
Format: Patent
Sprache:eng
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least one virtual table.