Query using a different index than expected

[Rahul Babbar]

Hi,

I have the table in which there are indexes on
Index1 --col1
Index2 --(col1, col2, col3, col4)

If i execute the query "Select * from Table where col1 =<value>,

It is using the Index2 and not Index1 to fetch the rows. This i can
find out from the explain plan.

As a result, it is taking much longer than expected to fetch the rows.

what could be the reason for it?

Is there some way we can force the optimizer to use a particular
index?

Thanks a lot

Rahul

[Tonkuma]

Please show the CREATE TABLE and CREATE INDEX statements.

[netzorro]

This is because you are executing a select *
Try with select col1 from table where col1=something
Diego

"Rahul Babbar" <ra***********@gmail.comwrote in message
news:83**********************************@c23g2000 hsa.googlegroups.com...

Hi,

I have the table in which there are indexes on
Index1 --col1
Index2 --(col1, col2, col3, col4)

If i execute the query "Select * from Table where col1 =<value>,

It is using the Index2 and not Index1 to fetch the rows. This i can
find out from the explain plan.

As a result, it is taking much longer than expected to fetch the rows.

what could be the reason for it?

Is there some way we can force the optimizer to use a particular
index?

Thanks a lot

Rahul