Archives of the TeradataForum
Message Posted: Sun, 03 Nov 2002 @ 14:30:59 GMT
The query joins two tables (uses two subqueries) and the two tables are indexed on their unique column (primary key). Intentionally, we did not fix additional indexes to the two tables to make the query run faster, we just left the indexes on the unique columns.
Any suggestions to rerun the tests with changes?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|