Types of Performance Tuning?

Answer Posted / anoop jb

There are many ways to improve database performance. One of them being creating indexes on table columns that are queried the most. Another is create table partitioning. A whole lot else can be accomplished at the report level by fine tuning the query or the filters created automatically by Cognos Report Studio

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of studio present in Cognos?

604


How to create model and how to test model?

594


how to explain health care project and which reports we can create in health care doain?

6341


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3908


What is model?

541






What is cognos reporting tool?

600


How create measures and demensions?

590


What are query items?

563


Why cognos scenario is used?

566


What are the methods by which it non-durable model could be changed into the durable model?

506


what is power prompt in cognos ep7series?what is the use of this?

3190


what are the filters in framework manager and report studio?

572


Explain what is the main advantage of impromptu over cognos reportnet?

589


What is the report studio?

584


What is the difference between low affinity and high affinity connections?

542