Archives of the TeradataForum
Message Posted: Mon, 01 Oct 2012 @ 09:28:02 GMT
Kindly clarify the point below.
We know Collect stats is a DDL operation.
Its the reason only one Collect stats can be do in a macro(??).
But when we do explain plan, it shows only Access lock putting on the table.
For DDL operation, exclusive lock should apply on the table(??).
Kindly give me a proper explanation on which lock will apply on a table as we do Collect stats.
Thanks in advance,
Sughesh I S.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|