On Apr 21, 2009, at 18:09 , Mark Devine wrote:
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.
contents and backups, and yes, you don't want to run queries against those.... -- Met vriendelijke groeten, Remco Post r.p...@plcs.nl +31 6 248 21 622
