Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Does Teradata have anything similar to Procedural caching (supported with SQL Server)
 
From:   Bhupesh Singu

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020