Subject | Identifying records in a table with the largest blobs |
---|---|
Author | Maya Opperman |
Post date | 2011-05-20T09:34:15Z |
Hi,
I've managed to identify which table is the largest in a database (by using gstat, and looking at the result summary in IBExpert) but now I need to know if there are one or two records causing more problems than others.
ie. I have a stock table containing images in 3000 records, and I need to be able to see if just a few of those records are much bigger than the others, so that those can be amended.
Any ideas how I can do that?
Thanks
Maya
[Non-text portions of this message have been removed]
I've managed to identify which table is the largest in a database (by using gstat, and looking at the result summary in IBExpert) but now I need to know if there are one or two records causing more problems than others.
ie. I have a stock table containing images in 3000 records, and I need to be able to see if just a few of those records are much bigger than the others, so that those can be amended.
Any ideas how I can do that?
Thanks
Maya
[Non-text portions of this message have been removed]