Obtree database cleanup – list of objects with most instances

This entry was posted by on Wednesday, 21 January, 2009 at

Note for me, do not forget that

select object_id, count(object_id) as x from objpicture group by object_id order by x desc

Replace objpicture with other tables as neeed, but the binaries will make up quite a bit of  content

Leave a Reply