Subject | Computed Fields |
---|---|
Author | Martin D. Berezaga |
Post date | 2002-08-31T13:36:28Z |
What should be a real life usage of COMPUTED columns?
In the case of some like:
CREATE TABLE EMPLOYEE
(FIRST_NAME VARCHAR(10) NOT NULL,
LAST_NAME VARCHAR(15) NOT NULL,
FULL_NAME COMPUTED BY (LAST_NAME || ', ' || FIRST_NAME));
To get the full name, I'd use the expression LAST_NAME ||
', ' || FIRST_NAME in a SELECT clause.
Is there a performance or some other kind of motivation to use COMPUTED
columns?
Thanks.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------
_______________________________________________________________________
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities.yahoo.com/v/pb.html
In the case of some like:
CREATE TABLE EMPLOYEE
(FIRST_NAME VARCHAR(10) NOT NULL,
LAST_NAME VARCHAR(15) NOT NULL,
FULL_NAME COMPUTED BY (LAST_NAME || ', ' || FIRST_NAME));
To get the full name, I'd use the expression LAST_NAME ||
', ' || FIRST_NAME in a SELECT clause.
Is there a performance or some other kind of motivation to use COMPUTED
columns?
Thanks.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------
_______________________________________________________________________
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities.yahoo.com/v/pb.html