Which gain better performance : multiple columns or use SQL built-in function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 26 Dec 2003 10:30 GMT

Hi all,
I have 1 table which need to store 7 days data in a row, I not sure
which table design will gain better performance in SELECT statement.
Desgin 1. 7 columns (day1, ..., day7) with char(4)
or
Desgin 2. 1 column (day_1_to_7) with char(28); to retrieve the data,
use substr function

Plz advise.
Thanks!
Whitepaper

Reply to this Message

Sathyaram - 26 Dec 2003 16:16 GMT

Though it depends on your application, my thought is that your Design
1 will perform better and easy to maintain .. Design 1 will eliminate
the overhead of SUBSTR function

Cheers
Sathyaram
www.db2click.com

> Hi all,
> I have 1 table which need to store 7 days data in a row, I not sure
[quoted text clipped - 7 lines]
> Thanks!
> Whitepaper

Reply to this Message