Home » RDBMS Server » Server Administration » Oracle sql query vs DBA functionality
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.
Previous Topic: Execute os file in Pl/SQL
Next Topic: Creation of Tree structure using PL/SQL
Goto Forum:
  


Current Time: Thu Mar 28 09:49:49 CDT 2024