Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: simple sql using between startnumber and endnumber not performing

Re: simple sql using between startnumber and endnumber not performing

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 29 Jun 2007 22:21:38 +0200
Message-ID: <f63pkb$d0o$1@news3.zwoll1.ov.home.nl>


-----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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US