Home » SQL & PL/SQL » SQL & PL/SQL » Performance issue with indexing
Performance issue with indexing [message #207442] Tue, 05 December 2006 10:15
Messages: 86
Registered: September 2006
Location: UK

Our users are experiencing the performance problem using Oracle 8.1.7 database. We are using Business object to display the data as required.

This is the below script using BO.

Can you please suggest me technically how to get resolved this issue?

Please let me know if you need any more information.


This is an example of the typical type of query I use, it works o.k. but I think some indexing could make it run much quicker.

I think the TEST.SH_TYS____COMPL.CLOSED_TIME & TEST.SH_TYS____COMPL.CANCELLED_TIME are key fields that could be indexed to speed up the report.

Also I tend to do a lot of reports using the TEST.TYS__COMPL_CONFIGURATION.OWNING_CENTRE as a filter, this isn't that large a table but
uses a table join on TEST.TYS____COMPL.CID = TEST.TYS__COMPL_CONFIGURATION.CID so indexing the TEST.TYS____COMPL.CID field could
provide an improvement.

The TEST.TYS____COMPL.CREATE_DATE is another key field when we want to identify tickets raised during a period.

The TEST.TYS____COMPL.SUBCASE_OF is another key field we filter by.

Previous Topic: sum function on two colums but same table
Next Topic: run monthly script automatically
Goto Forum:

Current Time: Thu Jun 22 11:41:03 CDT 2017

Total time taken to generate the page: 0.11756 seconds