Home » RDBMS Server » Performance Tuning » Performance tuning for a simple table with 2million records (Oracle 10g, windows server series)
icon12.gif  Performance tuning for a simple table with 2million records [message #358887] Wed, 12 November 2008 18:49 Go to next message
santhoshmohan
Messages: 1
Registered: November 2008
Junior Member
Dear all,

I am new to this forum.

Thanks in advance for all who are going to help me out.

actually my issue is, i am having a table which holds 2 million records.

i am using a java program and from web i am trying to search the records.

i am using a where condition and i am trying to fetch only one record from the table.

but my response time is very slow.

what are all the basic performance tuning steps that i have to do it in the table(in oracle).

please throw some light on this,

thanks & regards,
Santhosh
Re: Performance tuning for a simple table with 2million records [message #358893 is a reply to message #358887] Wed, 12 November 2008 20:17 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
A good place to start is the Oracle Performance Tuning guide

There are further links on the sticky thread at the top of this forum.

Ross Leishman
Re: Performance tuning for a simple table with 2million records [message #359658 is a reply to message #358887] Mon, 17 November 2008 21:51 Go to previous message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
use Partition table and index
Previous Topic: Query optimization
Next Topic: jobsq slave
Goto Forum:
  


Current Time: Mon Dec 05 15:03:31 CST 2016

Total time taken to generate the page: 0.36475 seconds