Great explanation and excellent solution proposals to the large tables problem! Thank you and keep up the good work!
@kareemabdul97303 жыл бұрын
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.
@azeezullasheriff77462 жыл бұрын
Excellent , Raj.. keep the Good work going on. I have forwarded this to my team, who do regular archives to include your best practices
@bluerays5384 Жыл бұрын
Good Learning today Sir, Thank you for Sharing.
@saket6 Жыл бұрын
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.
@aanchalsrivastava8550 Жыл бұрын
Can u tell in mysql how to create stored procedure that purge the data of table for defined period of time
@zawlinhtet46542 жыл бұрын
Thank you for very useful info 🙏
@P5toraskar19862 жыл бұрын
Good explanation thank you so much.
@tanveerkarbelkar2 жыл бұрын
@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?
@ZaneT5313 жыл бұрын
Nice tutorial man..
@ChennaiChannel2 жыл бұрын
Thanks for sharing.. useful
@himanish20062 жыл бұрын
If dimension table is continuously increasing then how do we manage ??
@rahulnepalallinone17943 жыл бұрын
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.
@panchadhara282 жыл бұрын
great video
@bhishambajaj8242 Жыл бұрын
Gold content
@krisharjunakinjarapu30713 ай бұрын
Where i can get all the videos
@rajasekhar_reddy_bolla3 ай бұрын
Can u contact me +91 9966246368
@kanakapavan42863 жыл бұрын
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_bolla3 жыл бұрын
just use union like select * from T1 union select * from T2. You don't need to keep the data again to main table
@avinash85352 жыл бұрын
@@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_bolla2 жыл бұрын
@@avinash8535 Sure Avinash 😀
@tanveerkarbelkar2 жыл бұрын
@@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 ?