>if i add an index in the table designer and have an expresion such as
>
>adddate != date()
>
>Will the date() be considered Dynamic or constant?
I'm not sure I know what do you mean by this?
Date() will be evaluated when the index is first built. When new records (nodes) are added to the index, those will use the current date not the date that was used when the index was first built. Unless you rebuild the entire index every day, the index nodes will not use the new date.
So yes for the most part, they are static.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao