Home » Developer & Programmer » Forms » Query Performance Issue in Oracle forms
Query Performance Issue in Oracle forms [message #294178] Wed, 16 January 2008 12:35 Go to next message
oracle1001
Messages: 4
Registered: December 2007
Location: chennnai
Junior Member
Hi All,

I am using oracle 9i DB and forms 6i.
In query form ,qry took long time to load the data into form.

There are two tables used here.
1 table(A) contains 5 crore records another table(B) has 2 crore records.
The recods fetching range 1-500 records.


Table (A) has no index on main columns,after created the index on main columns in table A ,the query is fetched the data quickly.

But DBA team dont want to create index on table A.Because of table space problem.

If create the index on main table (A) ,then performance overhead in production.
Concurrent user capacity is 1500.

Is there any alternative methods to handle this problem.

Regards,
RS
Re: Query Performance Issue in Oracle forms [message #294210 is a reply to message #294178] Wed, 16 January 2008 17:18 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
No.

David
Previous Topic: automating forms compilation
Next Topic: reading com port data
Goto Forum:
  


Current Time: Sun Apr 23 13:25:49 CDT 2017

Total time taken to generate the page: 0.18585 seconds