create onek(unique1=int4,unique2=int4,two=int4,four=int4,ten=int4,twenty=int4, hundred=int4,thousand=int4,twothousand=int4,fivethous=int4,tenthous=int4,odd=int4, even=int4,stringu1=char16,stringu2=char16,string4=char16)
create tenk1 (unique1=int4,unique2=int4, two=int4,four=int4,ten=int4,twenty=int4,hundred=int4,thousand=int4,twothousand=int4,fivethous=int4,tenthous=int4,odd=int4,even=int4,stringu1=char16,stringu2=char16,string4=char16)
create tenk2 (unique1 = int4, unique2 = int4,  two = int4, four = int4,ten=int4,  twenty = int4, hundred = int4, thousand = int4, twothousand = int4,fivethous = int4, tenthous=int4, odd=int4, even=int4,stringu1=char16,stringu2=char16, string4=char16)
copy onek from "_CWD_/../data/onek.data"
copy tenk1 from "_CWD_/../data/tenk.data"
copy tenk2 from "_CWD_/../data/tenk.data"
define index onek_unique1 on onek using btree(unique1 int4_ops)
define index onek_unique2 on onek using btree(unique2 int4_ops)
define index onek_hundred on onek using btree(hundred int4_ops)
define index tenk1_unique1 on tenk1 using btree(unique1 int4_ops)
define index tenk1_unique2 on tenk1 using btree(unique2 int4_ops)
define index tenk1_hundred on tenk1 using btree(hundred int4_ops)
define index tenk2_unique1 on tenk2 using btree(unique1 int4_ops)
define index tenk2_unique2 on tenk2 using btree(unique2 int4_ops)
define index tenk2_hundred on tenk2 using btree(hundred int4_ops)
retrieve into Bprime (t.all) from t in tenk1 where t.unique2 < 1000