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 is the main advantage of impromptu over cognos reportnet?

598


what is degenerate key in oracle ?whare do we use it?

2057


What are slice and dice?

526


Can you explain dynamic query mode?

581


How to deploy from one server to another server?

2013






how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

1692


how can you get the errors in job? when loops are araised we get error?

1648


Explain what is the difference between microstrategy and cognos reporting tool?

538


what is requery in cognos?

2062


What is main difference mapplets and mapping?

566


what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

2025


What are the types of catalogs in cognos?

671


Can you define dimension?

635


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1660


Can you define pivot?

539