If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can floating point numeric index use inequality in queries?
I have 2 floating point numeric columns that I am using in queries with
inequality criteria for those columns. Will indexes on those column be useful (i.e. can they be used to speed up the query)? |
#2
|
|||
|
|||
Can floating point numeric index use inequality in queries?
"harolde" wrote in message ... I have 2 floating point numeric columns that I am using in queries with inequality criteria for those columns. Will indexes on those column be useful (i.e. can they be used to speed up the query)? Yes. Depending on how the numbers are generated, though, you may have roundoff error causing mismatches - two values which look identical might be off in the last decimal place. |
#3
|
|||
|
|||
Can floating point numeric index use inequality in queries?
A criteria of = might be a problem; however or criteria might really
speed things up. A lot depends on the cardinality of your data. In cases like this, a good old-fashion stopwatch ends a lot of speculation. Just remember to do the timing after running the query at least once so that Access can optimize it. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "harolde" wrote: I have 2 floating point numeric columns that I am using in queries with inequality criteria for those columns. Will indexes on those column be useful (i.e. can they be used to speed up the query)? |
Thread Tools | |
Display Modes | |
|
|