changing the keys of an active ODS in production
I want to change the keys of a table active in production and holding data. There are a lot of queries on this ODS. My questions are
1. if I delete the data of the ODS in prod and change it keys and reload it, can I use the existing queries on the ODS as usual?
2. How do I find out what queries of this ODS are being used often? The ststistics on this ODS is not turned on.
rakesh elangovan replied
first when you change the key your are trying to change the table structure in data base level. so the earlier structure collapses onceonce you change it.
so the option you have left is to rebuild another ODS.
secondly you have to find out the queries used upon this ods.since you say the stastics are not maintained.
change all business enabled queries.(specially designed on requirments first)
importantly you can not use the queries unless it modified to current design.
reward points ifhelpful.