Subject | Re: Optized index |
---|---|
Author | skander_sp |
Post date | 2006-02-06T16:35:08Z |
> A constraint or an index?It's not a matter, I can create as need.
I think will be index because I need descending...
> Indices can be ASCending or DESCending, constraints create indicesTwo index? ASCending and DESCending? ok, I will try
> which are ASCending.
> Create an addition DESCending index and you should be home free.
> Generate some test data and test it's behaviour yourself.I no need generate more, I have loads of date, but trying never can
see they use great optimized, for only 3 years, always reading
thousands of record to look for MAX ...
In the case I exposed, what is the recomanded Indexes or Constraints?