Thanks ,
I understand that we can use either a UNION or a stored procedure,also saving the trips to the DB might not be expensive.
I have also got the idea of using a multi-dimensional view(CUBE- thereotically speaking) to make my data retrival faster.
My record structure varies for all the queries.Its something more like different tables
(USER_DETAILS,USER_LOCATION,USER_PASSPORT_DETAILS,USER_BANK_DETAILS,BANK_LOC_DETAILS,BANK_RATING,
USER_DEPENDANT_DETAILS,USER_INSURANCE_DETAILS,USER_ESTATE_PROPERTIES and so on)
Each of these details needs to be shown in different tabs fetching all at once.
After Query tuning i found no major difference in performance.
That is the reason why i thought of querying all of them either in a Single shot OR Creating a VIEW(for faster retrival of each table individually).
I need to find the best way to increase performance in this case.