| Bruinhx 2002-11-12, 12:23 am |
|
"Bruinhx" <bruinhx@yahoo.com> wrote in message
news:aqp5eu$l4i$1@zinnia.noc.ucla.edu...
> Hi,
> I have heard that text data type will have a performance drawback
than
> image datatype if they are both used to hold
> some text information that is not meant to be searched. Specifically, the
> operation of applying collation incurred by a text datatype is
> thought to be the cause of performance degration.
>
> Is this claim ture?
>
> I think collation will only be applied when comapring two text
columns.
> Hence, it will not make performance difference between using text to
> store text data and using image data type.
>
> Thanks!
>
>
>
>
|