what are determinants?
Answer Posted / madhoo
Determinants are used for to improve the query performance
these are like .... 1. Computer system and network capacity
2. Schema design
3. Database objects
4. Best practices for writing queries
5. Physical storage layout
6. Parallel query and Red Brick Warehouse configuration
computer host loaded correctly and network traffic problem
should be overcome....
A well designed Schema has most effect on query performance...
Database object give good performance .....those are Indexes
and predefined objects...
There are so many ways to write query on a logic...but with
the help of best practices only we can write well
performanced query.
.........
Any question on cognos and Sql .....let me wake up for
them at Cognos.madhoo@gmail.com
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain what is the difference between microstrategy and cognos reporting tool?
What is the difference between regular dimension and derminant?
Give me any example of semi and non additive measures?
Explain the different types of views used in cognos.
What is set to be Cognos configuration?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
When we save a report in report studio with what extn it save?
What is the difference between a data mart and a data warehouse?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What are shortcuts? Where it can be used? What are the advantages?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Name the types of gateway?
What is zero-foot print?
Define cognos report net?
What are the services provided in cognos 8?