Archives of the TeradataForum

Message Posted: Sun, 03 Nov 2002 @ 14:30:59 GMT

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

Dave,

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?

Thanks

-- Bhupesh

Bhupesh Singu
Database Administrator
Information Technology Department
State of Iowa

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