Updating one table from another

In general you should consider the following important points, focusing in the fact that there are two kinds of statistics: index and column statistics.

updating one table from another-76updating one table from another-52updating one table from another-90updating one table from another-79

Using UPDATE STATISTICS WITH FULLSCAN will scan the entire table.The simplest scenario is if you want to rebuild all the indexes and update all the statistics.As mentioned before, if you rebuild all your indexes then all the index statistics will also be updated by scanning all the rows on the table.If this is something you need to do all the time, I would suggest something else, but for a one-off or very small tables it should be [email protected]_horse_with_no_name: Oracle does not directly support the JOIN keyword in an UPDATE, but it allows UPDATE involving JOIN operations between table in at least 2 different ways, look at the accepted answer here: stackoverflow.com/questions/2446764/…

Leave a Reply