Re: Question bête

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Jean-Michel <jm130794(at)gmail(dot)com>
Cc: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Question bête
Date: 2013-01-07 18:00:28
Message-ID: m2vcb8kh4z.fsf@2ndQuadrant.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

Jean-Michel <jm130794(at)gmail(dot)com> writes:
> SELECT id from author where uuid ='82a2db11-55c2-2c04-8bdb-aba1fb'
> SELECT id from author where uuid like '82a2db11-55c2-2c04-8bdb-aba1fb%'

On peut avoir les EXPLAIN ANALYZE des deux requêtes ? Ça peut être un
index corrompu, dans le pire des cas.

--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

In response to

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Jean-Michel Choulet 2013-01-07 19:36:13 Re: [pgsql-fr-generale] Re: [pgsql-fr-generale] Question bête
Previous Message Christophe GARAULT 2013-01-07 17:03:55 Re: Question bête