Clob Column - performance implications

Database
Junior Supporter

Clob Column - performance implications

Hi,

I am researching to know the performance impact of using a clob column/XML columns in tables.

What are the situations wherein we should consider using a clob column ? What are the performance impacts of using a clob column if i want to use such a column in where condition or join conditions ? What are other implications that we should consider before designing such a table ? I know that clob objects create a subtable and it needs to be accessed to get the data for the clob column.

If you can give me some pointers to links/materials giving some details on this, then it will be very helpful.

I am reposting to bigger audiance then the connetivity section.

--Samir

1 REPLY
Enthusiast

Re: Clob Column - performance implications

Hi. I was writing a post on my blog about this topic. Basically, CLOBs are not stored in the base table but in a sub table. Depending if you select the CLOB column or not this may have an performance impact:

http://www.dwhpro.com/teradata-clob/

Best Regards

Roland

Roland Wenzlofsky