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: 4FE353C6.5060401@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-students

Amir,

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

Then:

SET enable_seqscan = false;

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

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

Browse pgsql-students by date

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