Re: [PERFORM] query cost too high, anyway to reduce it

On Fri, Dec 4, 2009 at 3:15 AM, nair rajiv wrote: > We populated the table with data and used EXPLAIN > > > dbpedia=# EXPLAIN   SELECT   nid,max(ssid) FROM gbobjects  where ssid<= > 10  group by nid  ; > >   QUERY PLAN >

[PERFORM] query cost too high, anyway to reduce it

-- TABLE STRUCTURE -- CREATE TABLE gbobjects ( ssid bigint NOT NULL, nid character varying NOT NULL, inid bigint NOT NULL, uid bigint NOT NULL, status character varying, noofchanges integer NOT NULL