ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[ADSM-L] Object size query

2009-04-21 12:12:22
Subject: [ADSM-L] Object size query
From: Mark Devine <mark AT MARKDEVINE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 21 Apr 2009 12:09:37 -0400 
I would like to query the DB for any stored objects > 1GB.  The output will
help improve our incl/excl specifications.

The only table/column I see is CONTENTS/FILE_SIZE.  My select works, but
obviously it's an intense scan.

Is CONTENTS the only place?  Please suggest the best approach.
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  [ADSM-L] syntax problem | preschedulecmd, goc
Next by Date:  Re: [ADSM-L] Object size query, Remco Post
Previous by Thread:  [ADSM-L] syntax problem | preschedulecmd, goc
Next by Thread:  Re: [ADSM-L] Object size query, Remco Post
Indexes:  [Date] [Thread] [Top] [All Lists]