| Oracle sql query vs DBA functionality [message #370520] |
Tue, 14 December 1999 16:40 |
James Kent
Messages: 1
Registered: December 1999
|
Junior Member |
|
|
I have a situation wherein i have a oracle form which when queried and activated gets data from oracle database. To increase the speed of execution i have indexed 2 columns of the table(combination index).Apart from that there are other columns in the same table which are indexed(but not being used by the query).Will the presence of these affect the time taken for the query to execute(the form is read only)?
Also since large data is being uploaded into data base daily what best can the DBA do to keep the query executing at the optimum time. Oracle 8 is being used. Can we used the partioning feature to do something about it.
Any help and suggestions will be appreciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
