Archives of the TeradataForum

Message Posted: Wed, 02 Oct 2002 @ 14:28:12 GMT

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

Nope, I don't. Views are just source, just like running separate queries. The optimizer might say something in the explain like the base table would be eligible for synchronous scanning (what the heck is that term anyway?), but it has no idea WHEN you're going to run queries with this source. And if you're using unique subsets of columns, what would it use for the index to the spool? The index has to be one of the columns after all, and if they're exclusive to each view, then, hey, what's it going to use? Perhaps more clarification would allow us to assist.

iv

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