[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQL indices a WC format bump and 1.7

From: Branko Čibej <brane_at_xbc.nu>
Date: Sun, 02 Oct 2011 21:26:09 +0200

On 02.09.2011 16:30, Philip Martin wrote:
> Bert also suggests changing our other indices by adding wc_id and/or
> local_relpath thus allowing them to be UNIQUE. Can anyone confirm that
> UNIQUE indices are better?

Just imagine, if the UNIQUE constraint did not imply an index, every
INSERT or UPDATE would have to scan the whole table in order to verify
the constraint. That would be ... less than efficient.

-- Brane
Received on 2011-10-02 21:26:46 CEST

This is an archived mail posted to the Subversion Dev mailing list.