Re: Creating an index on a view

Paul wrote:
> Does anybody have any thoughts on this?

Further thoughts: why use a function here in the first place? Just do this:

CREATE VIEW VIEW1
(IDCOLUMN,
 DESCRIPTION)
AS
SELECT T1.IDCOLUMN, T2.DESCRIPTION
FROM TABLE1 t2, TABLE2 T2
WHERE T1.ID = T2.ID; Much more efficient... Received on Thu Oct 13 2005 - 08:23:02 CDT