Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
COMPUTED columns and indices |
Fri, Jan 18 2013 9:59 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I've just used my first COMPUTED column in an index. I've probably slipped a cog here but since COMPUTED columns are not stored and calculated on the fly (at least that's my understanding) how does it work?
Roy Lambert |
Fri, Jan 18 2013 10:55 AM | Permanent Link |
Fernando Dias Team Elevate | Roy,
Exactly as if it was a stored column, except for the fact that the value is computed when needed when the index has to be updated or used as well as when the value is retrieved from the table. -- Fernando Dias [Team Elevate] |
Fri, Jan 18 2013 11:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
>Exactly as if it was a stored column, except for the fact that the value is computed when needed when the index has to be updated or used as well as when the value is retrieved from the table. But is the index stored? Or is it continually being updated or what? Roy |
Fri, Jan 18 2013 11:50 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |