Count(*) returns zero incorrectly ?!?

barry.marcus · Post by **barry.marcus** » Wed Feb 07, 2007 9:56 am

When I issue the command SELECT * FROM MYTABLE I get a endlessly scrolling list of rows (as I should, since there are ~ 10 million rows in the table.) But when I issue the command SELECT COUNT(*) FROM MYTABLE I get zero!

Any ideas as to what may be wrong? BTW, we just copied over the *.TBL from one machine to this one. How to we get the system tables in synch?

Post by **John** » Wed Feb 07, 2007 10:50 am

It sounds like you probably have indexes that weren't copied, and it is counting from the index. You should drop and recreate all the indexes, or make sure they were created identically and copied as well.