Re: Large table designissue
Thanks Rick.
Rick,all our tables integer columns in DB are BIGINT, so if i have convert this one column to INT, will indexes used when join this large table with other table.
I read indexes are not used when we have different data types
Subject
Written By
Posted
November 13, 2009 01:05PM
November 18, 2009 12:15AM
November 19, 2009 12:38PM
November 19, 2009 12:55PM
November 24, 2009 11:49PM
Re: Large table designissue
November 25, 2009 11:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.