Using hints...

[gjsaturday]

Hello!

I have two very similar tables.

T1 (only has today's data) with an index on time field
T2 (exactly like T1 but with historical data) no index

Is there a way with hints to utilize the time index from T1 on T2?

Forgive me if this is very simple, just trying to get a grasp of what's going on here as I can't build indexes and this t2 table has 4 million records.

TIA

 

[SantaMufasa]

GJ,

Since an index contains block/row pointers to physical data, you certainly cannot use an index on one table to access another table just because they have identical columns. As an example, it would be similar to trying to use an index for the Encyclopedia Britannica for the Oxford New English Encyclopedia just because they both have volumes for the 26 letters of the alphabet.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[amrita418]

Can you tell us what you are trying to do? As Mufasa already mentioned you cannot use index from one table on the other but if you need something like:

Select data from history (T2) table where date is someway related to date in the today'data (T1) that can always be done.

Regards,
AA