Re: [ADSM-L] Object size query
2009-04-21 15:11:34
Upgrade to version 6, and just run your SQL without fear. :)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mark Devine
Sent: Tuesday, April 21, 2009 10:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Object size query
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.
|
|
|