partition pruning with local index

[hrishy]

Hi

Well the answer is simple both the queries are different.

select count(*) from emptest where deptno=10;

I see that you have not created a index on deptno :-)

The query that is equivalent of
select count(*) from emptest
is
select count(*) from emptest partition(p1);

(dont look at the result i am saying optimizer wise they are equivalent now thats a term i made up)

I hope it answers your question

regards
Hrishy