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: 4FE353C6.5060401@agliodbs.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group