v$sql behavior

Hi Guys,

I tried to perform the test below:

1. create table customers with a single column and lod with value 1 to 100000

2. perform select * from customers where customer_id=1;

3. it's performing a full scan here, with sql_id dg7wum42kp2ky and plan_hash_value 2008213504 showing in v$sql

4. create index on the column, gather stats and perform select * from customers where customer_id=1; again.

5. now when i query v$sql, now it shows same sql_id with different plan_hash_value 387610350 as it's now doing an index scan.

what i'm puzzled is.. i'm expecting to see 2 rows here with similar sql id dg7wum42kp2ky .