How to query tables in a particular schema with less than 100 rows?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
First do a runstats on your whole schema. Then:
select tabname from syscat.tables where card < 100 and tabschema = 'theschema'
