cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create index on IX (a,b,c);
create index on IX2 (number,string,calendar);
insert into IX values (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);
insert into IX2 values (1,"one","01","1 January 1988");
insert into IX2 values (5,"five","05","5 January 1988");
insert into IX2 values (9,"nine","09","9 January 1988");
insert into IX2 values (13,"thirteen","0d","13 January 1988");
insert into IX2 values (17,"seventeen","11","17 January 1988");
select from IX,IX2 where IX.a = IX2.number;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * * * * * * *      a       b       c       d  number  string      bytes                                    calendar

     1       2       3       4       1  one         01                             January    1, 1988
     5       6       7       8       5  five        05                             January    5, 1988
     9      10      11      12       9  nine        09                             January    9, 1988
    13      14      15      16      13  thirteen    0d                             January   13, 1988
    17      18      19      20      17  seventeen   11                             January   17, 1988
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test joined select (2 tables) with composite indicies
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
