On Mon, Feb 27, 2006 at 02:17:23PM +0000, Simon Riggs wrote: > > Interesting point: how should EXPLAIN ANALYZE set these bits? For its > > own purposes it need not request random access, but it might be > > interesting to make it possible to examine both the random and nonrandom > > behaviors, now that these will be significantly different performancewise. > > Possibly we could make EXPLAIN ANALYZE EXECUTE set the random-access > > bits. > > Good point. Whichever we do will be wrong in some cases.... I've no real > opinion on this other than a vague preference for it to be quick.
Wouldn't an EXPLAIN ANALYZE DECLARE ... have the right information to know if backward scan, etc was needed? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
