Re: [ADSM-L] Object size query

Subject:	Re: [ADSM-L] Object size query
From:	"Conway, Timothy" <Timothy.Conway AT JBSSA DOT COM>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Tue, 21 Apr 2009 13:10:09 -0600

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.

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] Object size query, Mark Devine Re: [ADSM-L] Object size query, Remco Post Re: [ADSM-L] Object size query, Richard Sims Re: [ADSM-L] Object size query, Gee, Norman Re: [ADSM-L] Object size query, Conway, Timothy <=