1. sp_help mytable - one of the result will be info on your index on the table.try creating an index on fields used in JOINs and WHEREs.
2. depends on your query. the query am talking about is not the query used to access the view, but to create it. a view is basically a saved query. if it's ok with you, you can paste it here.
3. that may be considered as large data. so it will really take some time. also depending on the machine you're using...
My View is created as statement below (which naming as abc_view):
select tc_title, tc_from, tc_to, tc_begin, tc_end, locname,tt_name ,
name, designation, branch,ti_atten dance,
case when ti_result5>0 then ti_result5
when ti_result4>0 then ti_result4
when ti_result3>0 then ti_result3
when ti_result2>0 then ti_result2
else ti_result1
end as result
from trn_traineeinst ance r, trn_trainerinst ance i, trn_trainer t,
staff_history e, staffnamelistvi ew v,trn_course c, trn_location
where tti_tcode=tt_co de
and tc_code=tti_cco de
and ti_ccode=tti_cc ode
and ti_empkey=e.emp key
and e.empkey=v.empk ey
and tc_location=loc code
Then, I just use the statement below toretieve my data, but it took me almost 4mins to complete the retrieving process:
select * from abc_view
4
