about the discuss "SLOW" I posted before,

I tried “compute”. but I found when all the fields in a report are generated by “compute” , I cannot create Index for “INC_ID_NUM” when the output is “FOCUS database”.

(question: FOCUS DB has to have a index?)
So I cannot join the new table with other tables.

Need help!
Then is there any other way ?

hi, Tom
Thanks!
i can create Index now.

But the problem is : it is still slow.
So, changing to "compute" doesn't help.

Someone can help?Thanks!

Thanks!
Everyone.
I solved the problem.
The key problem is the JOIN.