Home » RDBMS Server » Performance Tuning » Performance improvement measures (Oracle 9i)
Performance improvement measures [message #327496] Mon, 16 June 2008 10:33 Go to next message
nishantstpl
Messages: 2
Registered: June 2008
Junior Member
Hi,

I have one table in the database which will hold around 90,000,000 records at a time. Could you please suggest what at performance measures i can take. I have to query this table on various columns of type number, varchar2 etc.

Regards,
Nishant
Re: Performance improvement measures [message #327497 is a reply to message #327496] Mon, 16 June 2008 10:37 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm


http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

[Updated on: Mon, 16 June 2008 10:38] by Moderator

Report message to a moderator

Previous Topic: SQL Needs to be tuned
Next Topic: Performance1
Goto Forum:
  


Current Time: Thu Dec 08 19:58:12 CST 2016

Total time taken to generate the page: 0.12635 seconds