Oracle 12C New Feature - Multi Column List Partitioning

[@nehaPrateek11]

Thanks for the great explanations can you please cover interval partitioning ? What is the motive of gather stats??

[@12ravindrareddy]

Same like, Can we use muti column range partition?

[@sucharurani6834]

Thanks Siva for the awesome teaching .. Please let us know how partation is improving the performance in back end

[@SivaAcademy]

Sure, Please stay tuned, i will add partition concept in seperate video series

[@apsarsk1394]

When we use the dbms_stats? Only it is performance based to get the statistics, if we not use what happen?

[@ankursrivastava5148]

Same que

[@shreeram2k3]

Hi sir, Is there any mail id to contact you? I need to clarify a situation in 12.1 I am using Subpartition template. becaused i don want to repeat the subpartition key for all the new partitions being created. So here i need a clarification, if in case i need to add new value to my Sub partition, i can use the SET SUBPARTITION TEMPLATE method to refresh the subpartition list. This will get effect only for the for going partitions. How we can make this effect to existing partitions? Can you please help me?

[@premgona5587]

Nice explanation Siva

[@SivaAcademy]

Thanks :-)

[@anupriya885]

Hi Siva ,Is it possible to give user-defined name for system generated partition name

[@sivachandra1603]

Hi sir can we create indexes on partition table . If yes please make a video on sir please sir

[@sangameshwarhippargi2007]

Please do create video on Oracle partition series

[@SivaAcademy]

Sure, please stay tuned

[@sangameshwarhippargi2007]

@@SivaAcademy I've learnt a lot from your videos . Thank you so much.😊

[@gurumoorthysivakolunthu9878]

Hi Sir, Partition is a very huge concept... You have covered only 2 types... rest of the types are not so important, Sir...? Thank you, Sir...

[@SivaAcademy]

Its important bro, will cover in upcoming videos

[@prasadk1468]

Nice

[@SivaAcademy]

Thanks

[@LGGift]

thanks bro.

[@SivaAcademy]

Welcome bro 🙏