Thank you very much all of you(Elliott Whitlow, Henry Treftz, GilaMonster) for your suggestion or further elaboration.

I explained more about the expected data size. Could you suggest me based...

Thank You very much for your information.

Let me explain more.

There are 5 main tables (Expected to grow fast). The expected amount of records (approximately) are shown below

Table 1: 600,000...

Sorry for cross posting. Thank you for your information

Realy thank you very much for your reply.

My problem is solved by other forum as follows. It is 100% correct

select registredBy.EmpFirstname,

...