Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Mike.

Asked: July 26, 2016 - 1:47 pm UTC

Last updated: September 01, 2021 - 10:11 am UTC

Version: 12 and 11.2.0.4

Viewed 1000+ times

You Asked

I know this is a newbie question but I have to ask to get an outside perspective. Table A has 20 columns of mixed data types and there are a number of large inserts run through out the day. Now here is the question no laughing Do stats impact the performance of the insert statements? if the insert statement is
insert into table A values ('values',2005,'values' etc) this statement loads 1000 of rows per run into table A

and Chris said...

For single row inserts, no. Gathering stats is a process you either run manually or let the background job handle.

If the insert is based on a query, then yes the stats affect the performance. But this is because they affect the plan Oracle chooses for the query. It's nothing to do with the insert.


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, July 27, 2016 - 12:24 am UTC

thanks

follow up on question

shajijoy, September 01, 2021 - 6:44 am UTC

Does table statistics has any influence on single insert statement with LOB content ? We were seeing the performance of LOB inserts degrade over a period of time and when we ran sql tuning advisor, it recommended collecting statistics for the table, as the statistics was stale.
Chris Saxon
September 01, 2021 - 10:11 am UTC

Only if there's a query in the insert statement.

If you can share details of your insert we can try to help further.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.