How to select 1 record from 1M records fast ?

DB:Oracle 11g R2 Standard One x64 on Linux

 I created a table with 1,000,000 records. Then I select a,b from tbl where xx=xx.
(With the real case we need do some joins)

Question is how can I select one row fast.
(maybe in 3 seconds)

With the standard edition we cannot use partition  tables.
Maybe we can tune it with creating indices.

I need some advice on the case.
Thanks a lot.

Best

Lau Lu Received on Thu Apr 15 2010 - 05:25:13 CDT