#DateWhereItemComment
406 Feb 2015 @ 04:37 PSTcarrie's blogWhy collect PARTITION statistics on Non-Partitioned tables?Thank you Carrie for your feedback.   But Based on the explaination in the blog i can't understand how extrapolation will still work with a current statistics for partition/summary. Let...
303 Feb 2015 @ 08:58 PSTcarrie's blogWhy collect PARTITION statistics on Non-Partitioned tables?Do collecting [partition] only stats on a daily basis for all tables will cause extrapolation process to never work ? we have an after data loadnig daily morning job which collects [partition] col...
204 Mar 2014 @ 07:18 PSTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherOn the Destination system i've allocated session = #of amps+3; however only ONE active seession and the other sessions is idle. Any ideas how to make the opertation faster by involving more sl...
104 Mar 2014 @ 07:13 PSTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to another@vineeta.v This is due to your are using Restore which expect same objetc with same id in the destination. you can use Copy instead: COPY DATA TABLES (DB1.tab1) (from(DB1.tab1)), abort, relea...