Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 09:49:19 GMT

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

Hi,

Whilst having problems getting the optimiser to use a Join Index, I thought of a way which could be used to guide the optimiser into using a Join Index.

The following addition would be made to the CREATE VIEW command.

     CREATE VIEW view_name AS JOIN INDEX join_index_name;

This command would effectively create a view using the SELECT clause from the specified Join Index, but it would also add an entry into the appropriate DBC table, that this view is associated with the named Join Index.

Then when the optimiser calculates an execution plan for a query which includes this view, it would ensure that priority is given to the use of the named Join Index.

Regards

Matthew Winter

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