> Were the changes to the indexes in 2.0 suppose to provide more than
> larger indexes?
>
> The reason I'm asking is because some of my queries still run just
> as slow in 2.0 as they did 1.5.2.
>
> Ex. SELECT distinct store_no from mytable; (Does a table scan)
> Thanks
>
> P.S. My restore time was cut in half from 50 mins on 1.5.2 to 26
> min with 2.0 !! (DB Size 2.6 Gig)
>
> System Specs:
> WinXP Pro. SP 2
> 2.6 MHZ
> 512 MB RAM
> ODSVersion = 11.0
> Charset = NONE
> PageSize = 8192
> PageBuffers = 32768
> SQLDialect = 3
> SweepInterval = 20000
> ForcedWrites = False
> ReadOnly = False
>

I hope you have adequate insurance with ForcedWrites set to OFF
Alan