I am having a table named "Society"
And 5 master tables "BlockA","BlockB","BlockC","BlockD","BlockE".
The "Society" table contains the foreign key columns of all the 5 master tables.
Now when i write the select query it takes a lot of time to execute, as 5 tables are referencing one table and joining those tables cause in delay result.
select Society.*,BlockA.*,BlockB.*,BlockC.*,BlockD.*,BlockE.* from Society inner join BlockA on Society.ABlock=BlockA.ID inner join BlockB on Society.BBlock=BlockB.ID inner join BlockC on Society.CBlock=BlockC.ID inner join BlockD on Society.DBlock=BlockD.ID inner join BlockE on Society.EBlock=BlockE.ID
So how to optmise my table structure or query