This video is outstanding.Recently we face this issue while archive log file got full.with the help of this video now I can suggest our developer to perform like this.
Good explication👌while archiving 1st time, why can't we use Select * into Employee_History_Arc From Employee_History; instead of batch processing? Hope optimiser utilize batch processing internally and may not occur any locking or blocking situations. Deletion should be done in batch processing. You could have given more explanation on best practices to implement archival solution. Like how to analyse tables, what all are the tables need to be taken from a DB to archive, what would be the the impact on U I application if we archive certain tables etc.
@RajasekharReddy Bolla sir I have two questions in this regard: 1. As the data is moved to T2, will it create less load on T1 for DML statements? Further, when you query T1 as part of the union, will it perform better than a single table? 2. If we create T1 & T2 two tables, is there a way we can create a single unique constrain on a single field combining both these tables?
Hello, could you please make a video on performance tuning that help us alot.also please suggest if there any link or website that hepl for learning dept in to performance tuning.
Hi Rajasekhar I have Doubt Regarding Data Archiving, While Main Table Some Data Inserted into Arch Table Strcuture. When ever we required data into Main Table then what need to do. 1) Is again insert Arch table data to Main table. Please Suggest me,Let me Correct if any thing Wrong.
@@rajasekhar_reddy_bolla Hi Sir, can you please make a video on performance tuning with large tables like 10M+ data.. Tips and tricks other than indexes, temp tables, etc.. Please??
@@rajasekhar_reddy_bolla sir i have two questions in this regards: 1. As the data is moved to T2, will it create less load on T1, for DML statements ? Further, when you query T1 as part of union, will it perform better than a single table ? 2. If we create T1 & T2 two tables, is there a way we can create a single unique constrain on a single field combining both these tables ?
This video is outstanding.Recently we face this issue while archive log file got full.with the help of this video now I can suggest our developer to perform like this.
Great explanation and excellent solution proposals to the large tables problem! Thank you and keep up the good work!
Excellent , Raj.. keep the Good work going on.
I have forwarded this to my team, who do regular archives to include your best practices
Good explanation thank you so much.
Thank you for very useful info 🙏
Good Learning today Sir, Thank you for Sharing.
great video
Thanks for sharing.. useful
Nice tutorial man..
Good explication👌while archiving 1st time, why can't we use Select * into Employee_History_Arc From Employee_History; instead of batch processing? Hope optimiser utilize batch processing internally and may not occur any locking or blocking situations. Deletion should be done in batch processing.
You could have given more explanation on best practices to implement archival solution. Like how to analyse tables, what all are the tables need to be taken from a DB to archive, what would be the the impact on U I application if we archive certain tables etc.
Gold content
@RajasekharReddy Bolla sir I have two questions in this regard:
1. As the data is moved to T2, will it create less load on T1 for DML statements? Further, when you query T1 as part of the union, will it perform better than a single table?
2. If we create T1 & T2 two tables, is there a way we can create a single unique constrain on a single field combining both these tables?
Can u tell in mysql how to create stored procedure that purge the data of table for defined period of time
Hello, could you please make a video on performance tuning that help us alot.also please suggest if there any link or website that hepl for learning dept in to performance tuning.
If dimension table is continuously increasing then how do we manage ??
02:00
Mssql tips
Hi Rajasekhar I have Doubt Regarding Data Archiving, While Main Table Some Data Inserted into Arch Table Strcuture. When ever we required data into Main Table then what need to do.
1) Is again insert Arch table data to Main table.
Please Suggest me,Let me Correct if any thing Wrong.
just use union like select * from T1 union select * from T2. You don't need to keep the data again to main table
@@rajasekhar_reddy_bolla Hi Sir, can you please make a video on performance tuning with large tables like 10M+ data.. Tips and tricks other than indexes, temp tables, etc.. Please??
@@avinash8535 Sure Avinash 😀
@@rajasekhar_reddy_bolla sir i have two questions in this regards:
1. As the data is moved to T2, will it create less load on T1, for DML statements ? Further, when you query T1 as part of union, will it perform better than a single table ?
2. If we create T1 & T2 two tables, is there a way we can create a single unique constrain on a single field combining both these tables ?
Where i can get all the videos
Can u contact me +91 9966246368