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
What is called Cognos powerplay?
What is looping and how to avoid it in framework manager?
What is a dimension?
what are the dimensions that you have in your current project?list them?
-------------How you design DWH?
What are the advantages of shortcuts?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Define dimensions?
Can you explain dynamic query mode?
What is meant by alternate drill down with ex?
how you provide security to reports? How you provide security to packages ?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Is it possible to join multiple Databases in a Catalog?
how to test reports in cognos?
Which lifecycle we will use for reporting?