Hey Krishna,

Were you able to achieve this? If yes

..

can you guide me how?

I believe XSLT is to transform XML from one format to another not generate from other file...

Hi,

According to my experience with the indexed views they are much more efficient then the SP's because they kind of create their own physical data structure but the best part...

Hi Lowell,

thanks for your response, but I do know the share DS and it is configured using oracle db provider; I wanted to know that which oracle client's library the...

Alright.. Lets follow it up with some "substantial" details -

our data contains tables which have cyclic dependency, there are transaction and master tables but its not necessary that master...

Really!

u may want to read the second line of the post dude!; BTW I believe I landed on the wrong place for this kind off question.

Thanks for reading that out...

You can see the exact query in SQL Server Profiler, create a new trace and start it before rendering the report

Open SQL Server Profiller - All programs -> MS SQL...

Thanks for your concern Mate!!

well the query is working absolutely fine, it is taking 10 seconds in SSMS, however on SSRS it is taking 3 mins.

Problem here is - During...

Thats a great solution but i have a problem, my parameters have multiselect option setting local parameters is giving me error, can any one help... please

Query -

DECLARE @LOCAL_VAR_ORGN VARCHAR(MAX)...

@chris-2

PFA the execution Plan...

this is not working.... 🙁

hahahaha.... at the end you have to trust DTA

well, inner query is not helping at all, Not getting any concrete solution for tuning this....

execution plan is not showing anything extremely...

Thanks for ur reply

- all 6 tables are required can't remove any of them

- Statistics are up to date, i have checked it

- Indexed view is used, table seek can...

Allright thanks for ur concerns!!

got it resolved now, used statistics PFB, the query

------------------------------------------------------

CREATE STATISTICS [_dta_stat_1233491523_19_15] ON [dbo].[AR_BHVR_DIM]([PD_KEY], [EMPE_KEY])

---------------

CREATE STATISTICS [_dta_stat_1233491523_1_19_15] ON [dbo].[AR_BHVR_DIM]([AR_BHVR_KEY], [PD_KEY], [EMPE_KEY])

------------

CREATE STATISTICS [_dta_stat_1998630163_1_3] ON [dbo].[CSTMR_DIM]([CSTMR_KEY], [CSTMR_NM])

------------

CREATE STATISTICS...

i have allready removed all table hints like nolock and distinct count before creating the indexed view, tried noexpand also, still cant force optimizer to pick from IV

Currently i am using SQL SERVER EE R2 2008

Thanks a lot for your reply

View is executing fine, but when i see the execution plan i dont see my select query reffring to this Indexed view, it is always...