This discussion is archived
1 Reply Latest reply: Feb 18, 2013 3:56 AM by John Stegeman RSS

Performace tuning column wise data store

SAMBIT RAY Newbie
Currently Being Moderated
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.

KEY Value
     agreesWith true
id 1
     assessment False
     basisForDateOfProgression 1
     bestOverallResponse 2
     bestOverallUnknownComments data is ok

Qurey:
select * from (
select t.agreesWith from t1 t
)a
join
(
select assessment from t1 t
)b
on a.id=b.id
In this manner we can join upto bestOverallUnknownComments .so which method we follow to reduce the execution time and performance should be good.
plz suggest..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points