Skip site navigation (1) Skip section navigation (2)

Re: index scan

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-students(at)postgresql(dot)org
Subject: Re: index scan
Date: 2012-06-21 17:03:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-students

> I have problem with EXPLAIN ANALYZE QUERY.
> I want to change a plan node, from seq scan to index scan.
> But i don't know the methode for it.

This is to test your indexing code?


 SET enable_seqscan = false;

Josh Berkus
PostgreSQL Experts Inc.

In response to

  • index scan at 2012-06-21 06:56:40 from Amir Sehan

pgsql-students by date

Next:From: Josh BerkusDate: 2012-07-09 19:34:15
Subject: Reminder: Midterms must be filled out *this week*
Previous:From: Amir SehanDate: 2012-06-21 06:56:40
Subject: index scan

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group