indexes in big character columns
From: Orlando L <oralrnr_at_gmail.com>
Date: Tue, 25 Dec 2012 23:53:27 -0600
Message-ID: <CAL8Ae74p5C_mGDdJcL2VSngWv+_BkLRSP_Nm0mfYns1KQKfSOQ_at_mail.gmail.com>
All,
Me and a colleague were having discussion about creating indexes in character columns that are big in size. He is of the opinion that big character columns should not be indexed. He could not explain why. I remember hearing about it, but did not know why that was the case. Does it still apply and can someone please explain. Thanks for the help.
Date: Tue, 25 Dec 2012 23:53:27 -0600
Message-ID: <CAL8Ae74p5C_mGDdJcL2VSngWv+_BkLRSP_Nm0mfYns1KQKfSOQ_at_mail.gmail.com>
All,
Me and a colleague were having discussion about creating indexes in character columns that are big in size. He is of the opinion that big character columns should not be indexed. He could not explain why. I remember hearing about it, but did not know why that was the case. Does it still apply and can someone please explain. Thanks for the help.
Orlando.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 26 2012 - 06:53:27 CET