Data Warehouse Query Performance

5 pts.
Tags:
Cognos
Data Warehouse Testing
SQL Server
We have a data warehouse with summary and detail level data with Cognos as the reporting tool.  If we have data for 100 large customers loaded in the fact tables and are trying to use Cognos Query Studio.  Here is the scenario:  one user has access to data for 5 customers through the security layer and another user has access to data for 25 customers.  Assuming the volume of data and other factors are the same per customer, should the query performance be slower for the user exposed to data for 25 customers versus the user with 5 customers?  If both users are using a customer select prompt and choosing 4 months of detail data, will the user with exposure to more customers have a longer response time?    

Software/Hardware used:
Cognos Query Studio and SQL Server
ASKED: May 21, 2010  1:24 PM
UPDATED: May 21, 2010  2:07 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Accessing more data will take more resources (time, I/O, sort, etc). But it will not take 5 times as long. Too many variables come into play to be able to calculate without running some benchmarks.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following