Return
-
Title
How does TOAD determines "Estimate table size?" -
Description
How does TOAD determines "Estimate table size?"
-
Resolution
Toad executes the following query:
SELECT SUM(DECODE(TYPE,'KCBH', type_size,0)) kcbh, SUM(DECODE(TYPE,'UB1', type_size,0)) ub1,
SUM(DECODE(TYPE,'SB2', type_size,0)) sb2, SUM(DECODE(TYPE,'UB4', type_size,0)) ub4,
SUM(DECODE(TYPE,'KTBBH',type_size,0)) ktbbh, SUM(DECODE(TYPE,'KTBIT',type_size,0)) ktbit,
SUM(DECODE(TYPE,'KDBH', type_size,0)) kdbh, SUM(DECODE(TYPE,'KDBT', type_size,0)) kdbt
FROM v$type_size
WHERE TYPE IN ('KCBH','UB1','SB2','UB4','KTBBH','KTBIT','KDBH','KDBT')