CODEWITHSUNDEEP
sqloracle-database
user3640957
user3640957

Reputation: 15

What alternatives are there to truncating and inserting for refreshing a table?

Without using truncate and inserting the data in a table for refreshing purpose is any alternative solution there?

My table contain 2000 records; we will add some more records.

Upvotes: 1

Views: 328

Answers (1)

Mureinik
Mureinik

Reputation: 311843

2000 records is a small table, on any reasonable RDBMS and with virtually any reasonably modern hardware. Just delete the records you don't need or update the ones you do.

Upvotes: 1

Related Questions