any script to find out how many rows of data each table of the database has ?
I want to quickly found out if I need to create index for table which is so small ! I heard that if the table has <= 1000 rows, basically let the SQL optimizer do a full scan is faster than using the index, right?
is 1000 rows still right? or 2000 ? which is the maximum number of rows of a table should have that a full table scan is better than having index on it ?