-
MDX Query is slow when execute using linked server
Hi,
I am having 2lac records in a cube, my requirement is to get the cube results using openquery and linked server. When i try to execute this query it take more time when compare to the normal sql query.
Is there is any thing i am doing worng or can someone help me to improve the performance.
This is the query is trying
SELECT * FROM OPENQUERY(olap_server,
' Select
[PATIENT_DETAILS:Pres Patient First Name],
[PATIENT_DETAILS:Pres Patient Last Name]
from
[Patient_details]
WHERE
[PATIENT_DETAILS:Pres Patient First Name] = ''DENISE''')
Please help me
-
Is This a Duplicate Post?
Isn't this the same issue as you are attempting to describe (albeit initially from another angle) in "Can we use Analysis service to create a cube for huge records?"
If so, let's try to keep the threads together to make this a little less confusing.
Your consideration is appreciated.
Bill
-
How to keep the threads together
How to keep the threads together. Please let me know
-
In this case, work with the parallel post only ...
Thanks for helping us to keep it easy for subsequent searchers to see full dialogs / solutions!
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|