ABMOOL

• Jul 30th, 2012

 

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.

Thanks

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

 

Practice to use UNION ALL in place of UNION since it is faster than UNION as it doesnt sort the result set for distinguished values.

Jay

• May 10th, 2014

 

1. Ensure joins are perfectly done

2. Ensure Indexes are made to the specific columns (Such as Search Column)

3. Try to use Summary Tables

4. Materialized views

Lakshmikar

• Apr 5th, 2016

 

1.Partitioning
2.Indexes
3.Avoid maximum no. of joins.

Khalid Mehmood Awan

• Jul 25th, 2017

 

Creating Table Partitions, Indexes, Materialized views, remove normalization where it is unnecessary, increasing hardware power and many other factors.