if you count from other session and you have not issue commit then for your counting session there is no rows
if your table b has NO primary key it will use Full Table Scan which is slower if you are counting the whole table
|
Results 1 to 9 of 9
Thread: Not getting count of rowsThreaded View
|
Click Here to Expand Forum to Full Width |