Lines Matching refs:is_index
48 is_index boolean, -- TRUE if it is an index, false for a table
73 proc isleaf {pagetype is_index} {
74 return [expr {$pagetype == "leaf" || ($pagetype == "internal" && $is_index)}]
76 proc isoverflow {pagetype is_index} {
79 proc isinternal {pagetype is_index} {
80 return [expr {$pagetype == "internal" && $is_index==0}]
90 set is_index [expr {$name!=$tblname}]
94 sum(isleaf(pagetype, $is_index) * ncell) AS leaf_entries,
96 sum(isoverflow(pagetype, $is_index) * payload) AS ovfl_payload,
99 sum(isinternal(pagetype, $is_index)) AS int_pages,
100 sum(isleaf(pagetype, $is_index)) AS leaf_pages,
101 sum(isoverflow(pagetype, $is_index)) AS ovfl_pages,
102 sum(isinternal(pagetype, $is_index) * unused) AS int_unused,
103 sum(isleaf(pagetype, $is_index) * unused) AS leaf_unused,
104 sum(isoverflow(pagetype, $is_index) * unused) AS ovfl_unused
128 $is_index,
261 SELECT DISTINCT tblname FROM space_used WHERE $where AND is_index=0
266 WHERE $where AND is_index = 0
385 WHERE NOT is_index AND name NOT LIKE 'sqlite_master'}]
425 subreport {All tables} {NOT is_index}
427 subreport {All indices} {is_index}
429 foreach tbl [mem eval {SELECT name FROM space_used WHERE NOT is_index
437 subreport "Indices of table $name" "tblname='$qn' AND is_index"
