Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2006 @ 10:32:42 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Question on Hash Map

From:		Victor Sokovin

Naveen;

The article describes about how the cop is selected from among the available cops? Can you let me know what does cop refer to?

Basically, it refers to a node. In your case you could have up to 8 entries. COP selection algorithm will pass on user's query to a certain node. From there on the query will be in the hands of the optimizer. I see that other posters have shed more light on that part of query routing.

So, it's like 8 doors through which you can enter. It does not matter which one you use. Of course, some nodes can be more advanced than the others, so it is sometimes worth monitoring that the older nodes do not get too many requests. COP selection algorithms offer enough flexibility for that.

Regards,

Victor