Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: simple sql using between startnumber and endnumber not performing
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Malcolm Dew-Jones wrote:
>
> table X
> startnumber NUMBER
[snip]
> index on all four columns
>
> SELECT *
> FROM X
> WHERE '3131' BETWEEN start_helper and end_helper
Not using index - implicit conversion - BAD!
Don't tell - but comparing numbers is much faster that
comparing strings - hence my homework assignment.
- --
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD8DBQFGhWnSLw8L4IAs830RAmCeAJ9V/Qw4HbZ9o7jucRYOSyB77eYnsQCeN5cJ
JjVC9cFksXiIaO+AojSYUJo=
=uILO
-----END PGP SIGNATURE-----
Received on Fri Jun 29 2007 - 15:21:38 CDT