how to tune qurey for coulumn wise data saved.because we have to join same table n number of times.for reference go through the following scnarios.
Suppose one table T1 is there and it has two column KEY and VALUE.if we are writing qurey for retriving desire result in row manner we have to join samae table no of times.
bestOverallUnknownComments data is ok
select * from (
select t.agreesWith from t1 t
select assessment from t1 t
In this manner we can join upto bestOverallUnknownComments .so which method we follow to reduce the execution time and performance should be good.