Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Question: ElevateDb have still limitation on using compound indexes in queries?
Mon, Oct 23 2006 11:22 AMPermanent Link

"Stefano Monterisi"
Hi Tim,

ElevateDb still have the limitation on using indexes created on multiple
fields in queries with "and" in where ?
I intend if the partial-optimized (first field only) is the same or if there
is a new full usage of the index (with best performance).
Only for plan my work Smile

Thanks,

Stefano Monterisi

Mon, Oct 23 2006 4:28 PMPermanent Link

"Jose Eduardo Helminsky"
Stefano

As I know, it will work in the same way, at least in the first builds.

Eduardo

Mon, Oct 23 2006 5:14 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Stefano,

<< ElevateDb still have the limitation on using indexes created on multiple
fields in queries with "and" in where ? I intend if the partial-optimized
(first field only) is the same or if there is a new full usage of the index
(with best performance). Only for plan my work Smile>>

Eduardo is correct - it will be the same, at least initially.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image