Oracle 11.2 G
I am joining a table where I only need two fields the join key and one other field. If I created a concatenated index that contained the two fields would oracle determine that it can get all the needed information from the index and avoid a full table scan. The table has 71 million rows with an avg length of 307 bytes and takes 500K blocks. So, I would like to avoid the I/O necessary to read this table.
Thank you.
I am joining a table where I only need two fields the join key and one other field. If I created a concatenated index that contained the two fields would oracle determine that it can get all the needed information from the index and avoid a full table scan. The table has 71 million rows with an avg length of 307 bytes and takes 500K blocks. So, I would like to avoid the I/O necessary to read this table.
Thank you.