| Home / Oracle / Database / Name 3 ways to get an accurate count of the number of records in a table? |
Name 3 ways to get an accurate count of the number of records in a table? |
||||
SELECT * FROM table1
SELECT COUNT(*) FROM table1 SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2 |
||||
Powered by
KBPublisher (Knowledge base software)
