select count(*) gives different value
638917Aug 26 2009 — edited Aug 26 2009Hi Experts,
I have a table with more tnan 50 thousand records with 8 indexes.
When i am trying below query
select * from customer_table
WHERE line_id IS NULL
AND balance >= 0
AND dept_code = '233'
AND overline IS NOT NULL
AND rstat= 'O'
AND astat ='A';
i am getting 61 rows however when i am trying
select count(*) from customer_table
WHERE line_id IS NULL
AND balance >= 0
AND dept_code = '233'
AND overline IS NOT NULL
AND rstat= 'O'
AND astat ='A';
i am getting 43. it is strange to get different results..
I did index rebuild and even recreation of indexes also..still same result..
does any body have any clue abut this...
plz help..