| Subject | Acsending or Descending Index |
|---|---|
| Author | Vander Clock Stephane |
| Post date | 2012-01-24T17:36:22Z |
Hello,
Without the consideration of the order by, i there any difference
between ascending and descending index for queries like
select ... where fieldA > 123;
select ... where fieldA = 123;
select ... where fieldA < 123;
or both gave the same performance ?
thanks
stéphane
Without the consideration of the order by, i there any difference
between ascending and descending index for queries like
select ... where fieldA > 123;
select ... where fieldA = 123;
select ... where fieldA < 123;
or both gave the same performance ?
thanks
stéphane