Home » RDBMS Server » Performance Tuning » Query Performance (Oracle 11g)
Query Performance [message #616474] Tue, 17 June 2014 04:37 Go to next message
Messages: 15
Registered: May 2011
Junior Member
Please guide me the performance of SELECT query on a table for below scenarios.

I have a very big table with 20crores records in it.
Daily i need to insert/update/delete 10 lacs or 15 lacs records into this table and at the same time need to run SELECT query on this table.

In this case the performance of the SELECT query will be reduced? If yes in which scenarios and also please guide me some references for this type of requirement

Re: Query Performance [message #616476 is a reply to message #616474] Tue, 17 June 2014 04:54 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
20 crores/lacs? Please use standard units. Crore would be 10 million.
Re: Query Performance [message #616478 is a reply to message #616476] Tue, 17 June 2014 05:01 Go to previous messageGo to next message
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
It might degrade, it might not.

It depends on what data you are selecting, how it is being accessed, how frequently it is being accessed and all of these compared to the blocks you are altering. You'll have to test it, basically.
Re: Query Performance [message #618465 is a reply to message #616478] Sat, 12 July 2014 02:09 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
To summarize:

you have a 200 million row table into which you insert 1 million rows per day.
You want to know if queries will slow down as the number rows in the table increases.


if your queries fetch more rows as the number of rows increases (either because the queries actually want more rows, or the are forced to scan more rows and throw unwanted rows out due to bad design), then they will go slower.

If however due either to partition pruning, or indexing, or other features, your queries are fetching about the same number of rows regardless of the total number of rows in the table, then your queries will take about the same amount of time.

Previous Topic: How about performance using index on the column which is using in WHERE and SET clause.
Next Topic: Oracle 11g on VMWARE
Goto Forum:

Current Time: Sun Sep 19 22:07:49 CDT 2021