[prev] 24 [next]

Relation Copying

Consider an SQL statement like: 

create table T as (select * from S);

Effectively, copies data from one file to another.

[Diagram:Pics/scansortproj/file-copy.png]

Conceptually: 

make empty relation T
for each tuple t in relation S {
    append tuple t to relation T
}