Hi, My table 'A' has 11 million rows . I created temp table 'B' same as table A and inserted rows upto 4 million from table 'A' using where caluse.
The data was inserted fine without any errors, But when Iam trying to do a row count on table 'b'.
selct count(*) from b.
But it is not giving me any output. It has been more than 30 min but still there is no output. Table A rowcount gives me in few seconds. Can any one let me know what the problem could be??