Archives of the TeradataForum
Message Posted: Thu, 03 Oct 2002 @ 00:42:16 GMT
Synchronized scanning is Teradata's ability to use the same i/o to a data block to satisfy multiple queries.
Say you have two queries which are running concurrently and that each query's join plan includes a full table scan of a particular table. When the AMP step (for a particular query) that performs a table scan starts Teradata looks to see if there are any other queries which are also doing a scan of the same table. If there are, then the AMP step which has just started will read the same data blocks that are being read from disk for the already running query. This allows Teradata to utilise the same physical i/o to satisfy multiple queries.
There's a bit more to the process and explanation, but that's the basis of it.
Any more questions feel free to ask.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023