Hi,

is there a possible way to find if select query fired is doing a table scan or an index scan?

I have a table with xactlt 3 lac and 14 rows.....
and a select query takes ages to to retrive result....
though 5 cols have been indexed...
any suggestions welcome
thanx