Groups > comp.databases.oracle.misc > #793

Re: Query optimization

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Robert Klemme <shortcutter@googlemail.com>
Newsgroups	comp.databases.oracle.misc
Subject	Re: Query optimization
Date	Sat, 11 Jan 2014 11:55:54 +0100
Lines	23
Message-ID	<bjcm9rFsdo2U1@mid.individual.net> (permalink)
References	<d9svc9htpv6k2mniepdfhp08jgmk7o25k6@4ax.com> <yHTzu.193917$5Z5.148829@fx05.iad> <8n70d9l87hqm7p5n55o0pa4c1h9qlj0gbq@4ax.com>
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net ZbYXEi27KGRZH522k5Cx+QUZgTWH2lRDg8z8hTZbk88kErGn0=
Cancel-Lock	sha1:oJAyqMrNmA0S4aG+8pY9lq5TWsk=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0
In-Reply-To	<8n70d9l87hqm7p5n55o0pa4c1h9qlj0gbq@4ax.com>
Xref	csiph.com comp.databases.oracle.misc:793

Show key headers only | View raw

On 10.01.2014 17:33, Mark wrote:
> On Fri, 10 Jan 2014 14:44:46 GMT, "Ken" <ktsahl@yoohoo.com> wrote:

> The query is as simple as this:
>
>     SELECT column FROM table WHERE x = 'a' AND y = 'b' AND z = 1;
>
> There is an index on x, y and z.

Do you mean "there is a covering index on (x, y, z)" or do you mean 
"there is an index on x, an index on y and an index on z"?  If the 
latter, try the covering index with the most selective column first.

> Anyway my client has solved the problem by setting the statistics to
> NULL.

Other queries aren't hurt?

Cheers

	robert

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-10 13:14 +0000
  Re: Query optimization "Ken" <ktsahl@yoohoo.com> - 2014-01-10 14:44 +0000
    Re: Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-10 16:33 +0000
      Re: Query optimization Robert Klemme <shortcutter@googlemail.com> - 2014-01-11 11:55 +0100
        Re: Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-13 10:05 +0000
      Re: Query optimization "Ken" <ktsahl@yoohoo.com> - 2014-01-13 03:08 +0000
        Re: Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-13 10:07 +0000
          Re: Query optimization "Kirby Grant" <kgrant@whatzit.org> - 2014-01-13 13:24 +0000
            Re: Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-13 15:32 +0000
  Re: Query optimization ddf <oratune@msn.com> - 2014-01-10 08:24 -0800
    Re: Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-10 17:03 +0000
      Re: Query optimization ddf <oratune@msn.com> - 2014-01-10 15:39 -0800
      Re: Query optimization joel garry <joel-garry@home.com> - 2014-01-10 15:46 -0800
        Re: Query optimization Mark <i@dontgetlotsofspamanymore.invalid> - 2014-01-13 10:51 +0000

csiph-web