Can't create a join index
842430Feb 24 2011 — edited Feb 24 2011Hello all,
I have a problem in creating a join index. I don't know what is wrong here. After I ran this create statement I get the error "invalid CREATE command".
create join index l_index
on l_summyyyy_test a(a.agent_type)
from l_summyyyy_test a,l_cammyyyy_test b
where a.number=b.number and
a.agent_code=b.agent_code
;
Can anybody help me with this?
Thanks a lot,
Laura