Hello,

I have read that in a case where a table has many columns, but most of the time only one of them is used (say a title column in a forum post), a way to increase performance would be a partition to two tables, where one will contain only the title and the other one will contain the other columns (such as the forum post body).

However, in case I use

select ForumTitle from Forum;

won't that be good enough to prevent the load of all columns (such as the forum post's body) to the memory, and eliminate the need of partition?

Thanks,

Joel