kts

• Mar 22nd, 2006

 

- make sure to have the right context

- apply right indexes on the tables

Sandeep Dudhane

• Apr 8th, 2007

 

There are various strategies like creating indexes to the columns, creating aggregate tables, creating filters (usually on date columns)

jay jaiswal

• Jul 1st, 2007

 

You can partition the table, create proper indexes on that column,
You can define key type in Object Definition,
Use aggregate Awareness.

Tilak kumar

• Aug 7th, 2007

 

1) Frequently used tables only you need to create the indexes.
2) Partioning the tables
3) Reduce the user defined objects
4) Always use the conditions, avoid string concatenations.

Balaji

• Oct 25th, 2007

 

do not use more then one sub-query for the single report..this would help you in access the report faster

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre 

• Dec 19th, 2007

 

Make sure the following along with those specified our friends.
Use of possible short cut joins.
Cheers,
Ravi Kumar Garre
Phone: +91-9820350246

sreya_1234

 Profile Answers by sreya_1234 Questions by sreya_1234

• Jan 31st, 2008

 

Make sure
1) you do not have traps in the universe.
2) use the right context
3) avoid morethan one sub query in the query panel

rahul07

 Profile Answers by rahul07 

• Apr 23rd, 2008

 

1) check for any traps in the universe.
2) use the right context
3) avoid morethan one sub query in the query panel
4) use right context
5) right index on the table
6) partion the table
7) use conditons
8) avoid user defined objects

abdul123

 Profile Answers by abdul123 

• May 2nd, 2008

 

Avoid too much of Report level formulae.

sreenivas27

 Profile Answers by sreenivas27 

• Jul 1st, 2008

 

Hi

First you have check your report format i.e filters,conditons, graphics, sorts, ranks....

mainly these you have check so that you can decided which option u can use better....

so that you can easily tune your query performance.


Regards,

Sreenivas.