Hi all, My database has data for a period of 2 years of intra day data. I want to optimize certain parameters on a programme on the data of last 6 months only. It takes 15 minutes for optimization.
If I export only the the data of only last 6 months to a separate database (this database will contain only this 6 months data), it takes only 5 minutes for the same optimization. That is, for the same optimization on 6 months data, it takes long time if I use larger database, and takes less time if I use a small database. The problem is that I have to export the last 6 months data to a separate database every time I want to do optimization. I am sure there might be some way by which I could do the optimization on the main data base itself, without taking long time. Can somebody tell how to achieve this. With best regards UMR Perumal