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.post AT plcs DOT nl
+31 6 248 21 622