Archives of the TeradataForum
Message Posted: Thu, 24 Jun 2004 @ 09:49:19 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|