jsk423 Posted August 26, 2013 Report Posted August 26, 2013 I have a universe which has 900 tables in it...My manager asked me to find a way so that you can reduce the number of tables to 500-700 ...So ela approach avvali? Also eee universe meeda document prepare cheyyaali...if any body has a template can some one please email me? I will pm you my email address... Thanks in advance.
tylerdurden Posted August 26, 2013 Report Posted August 26, 2013 Universe meeda peddaga knowledge ledu vayya.. .. LTT
bob234 Posted August 27, 2013 Report Posted August 27, 2013 no longer use cheyani tables theesey....and more over konni tables lo loads eppatinundo aagipoyi undavachu.......so query each table against the database and check for max of loaddate........loaddate mari years back unte then u shud think abt deleting it.....also ekkadaina avasaram unna chota better use derived tables.......
CheGuevara Posted August 27, 2013 Report Posted August 27, 2013 why dont you create another universe with some tables taken from this universe
jsk423 Posted August 27, 2013 Author Report Posted August 27, 2013 inkoka universe create cheyyadaniki inkoka 1 year padutundi 500-700 tables tho
Recommended Posts