Howdy!
In 12.10b7 (and also 12.9 GA), I have this query:
SELECT
bm.table_name,
dt.blocks8192/1024/1024 size_mb,
SUM(bm.expected_rows) rows_to_del
FROM busy_master bm JOIN dba_tables dt ON bm.table_name = dt.table_name
WHERE dt.owner = ‘ASDKLF’
GROUP BY bm.table_name, dt.blocks8192/1024/1024, dt.num_rows
ORDER BY 2 DESC;
I want to add “dt.num_rows” to the columns selected, so I add a row in the SELECT columns, type “dt.” and wait 1500ms. The Toad Insight popup shows with all of the columns in DBA_TABLES. I type “N” in the filter and the columns all disappear. If I simplify the query down to:
SELECT
bm.table_name
FROM busy_master bm JOIN dba_tables dt ON bm.table_name = dt.table_name;
…Toad Insight works as expected when I add the new column. Thoughts???
TIA!
Rich