Have a query like this:
select count(*) from T1 where c1 = 'str1' and c2='str2' and c3='str3';
It complains "waits a long time for 'direct path read'. Are there any possible ways to tune the query? What kind of indexes can I create? Can any gurus shed some lights on it?
Thanks in advance.