ADSM-L

Re: TSM DB design (was Re: TSM 5.1 Performance Tuning Guide - Where?)

2002-07-23 09:10:42
Subject: Re: TSM DB design (was Re: TSM 5.1 Performance Tuning Guide - Where?)
From: Paul Zarnowski <vkm AT CORNELLC.CIT.CORNELL DOT EDU>
Date: Tue, 23 Jul 2002 09:09:40 -0400
At 01:00 AM 7/22/2002 +0200, you wrote:
Not all joins take ages - the trick is to know not only the tables but
also the indexes and use them.

It's important to realize that some of the tables that you can issue
'select' statements on are not actual tables in the database, but are
rather constructed on the fly.  The 'select' statement is a convenient way
to get at the data in the database.