Jump to content

Data Modelling & Performance Tuning (Oracle)..help


Recommended Posts

Posted

data modelling and Oracle performance tuning complex scenarios with solutions telsinavallu post cheyandi please... Interview undi naku... 

 

complex issues face chesanu and I resolved it  ani detailed ga explain cheyadaniki... 

 

Aggregate tables and denormalized tables create chestham kada to improve performance. Also, indexing etc.. ivi nenu real time chosinavi..inka meeru choosinavi chesinavi..please post here with solutions 

 

Thanks

 

 

 

 

Posted

data modelling and Oracle performance tuning complex scenarios with solutions telsinavallu post cheyandi please... Interview undi naku... 

 

complex issues face chesanu and I resolved it  ani detailed ga explain cheyadaniki... 

 

Aggregate tables and denormalized tables create chestham kada to improve performance. Also, indexing etc.. ivi nenu real time chosinavi..inka meeru choosinavi chesinavi..please post here with solutions 

 

Thanks

aggregate tables and normalized tables antae ento info share cheyandi please!!!

Posted

aggregate tables and normalized tables antae ento info share cheyandi please!!!

aggregate tables roll up chesthundi data ni motham...big fact table unnapudu at granular level data ni...adi antha querying cheyadam time taking kabbatti..create an aggregate and roll up the data to higher dimensional level and use it in reporting..

 

denormalization valana sql number of passess taguthay...idi based on requirement chesukovali...

Posted

aggregate tables roll up chesthundi data ni motham...big fact table unnapudu at granular level data ni...adi antha querying cheyadam time taking kabbatti..create an aggregate and roll up the data to higher dimensional level and use it in reporting..

 

denormalization valana sql number of passess taguthay...idi based on requirement chesukovali...

looks lil complex .. but that u 

Posted

evar leraa Data modelling and performance tuning telsina vuncles

×
×
  • Create New...