on 05-21-2014 8:44 AM
Good morning,
I'd like to know if there are any ways to estimate the size of a table after a delete statement.
Let's say I have a table table_A with 1000000 rows and sized 10Gb (info retrieved from sp_spaceused table_A)
I know I'm going to delete 350000 rows and I'd like to estimate the size of my final table, how can I proceed?
Can I just do a mathematical rule to estimate the size?
Should I use optdiag ouput to know the size of a row and 'x' by number of rows?
Thanks
Simon
Thanks Mark and Bret for your answers.
the only way to know is to test
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you will follow up the delete with a REORG REBUILD of the data, you can use the sp_estspace procedure to get an estimate of the table size. (it assumes minimal fragmentation, which is all that variability Mark described so well).
-bret
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.