Archives of the TeradataForum
Message Posted: Mon, 01 Jul 2013 @ 15:01:38 GMT
| Subj: || || Re: Access count in DBC.Indices |
| From: || || Bakthavachalam, Roopalini |
Thanks Dave!! Understood. Can you tell me , what value you recommend? I read in the manual that 10 is the least value and anything lesser than
that would impact performance. Would 30 be an appropriate value? Would it cause any contention /locking/blocking when ETL jobs are running? Once
we capture the data regarding index, columns ect, should we again make to 0?
Really appreciate your time and inputs.