How many rows are there in that table, and can you read the clustering factor of the I_RBK_ID index from user_indexes? I'm wondering whether you might be better with a full table scan here.
|
Results 1 to 6 of 6
Thread: Query doing lot of disk reads.Threaded View
|
Click Here to Expand Forum to Full Width |