| Query Performance Issue in Oracle forms [message #294178] |
Wed, 16 January 2008 12:35  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
