Hi Folks, It´s just for curiosity I ask:
Could an INDEX speed up that SELECT? Thanks in advance, and sorry for my newbies questions. André (Brazilian User) > On Thursday 28 October 2004 11:16 am, Gary Stainburn wrote: > > Hi folks. > > > > I have the following view: > > > > CREATE VIEW "stock_available" as > > SELECT * FROM stock_details > > WHERE available = true AND visible = true AND > > location not in (SELECT descr FROM ignored); > > > > Stock_details is itself a view pulling in a number of tables. > > Everything works fine until I try to pull in only the details for a > > specific branch, using the following. > > > > select * from stock_available where branch = 'Leeds'; > > or > > select * from stock_available where branch = 'Doncaster'; > > > > At this point, the query takes 11 seconds. Any other quiery, > > including > [snip] > > Once thing I forgot to mention. If I run the above on the base view > stock_details, it returns in < 1 second too. > -- > Gary Stainburn > > This email does not contain private or confidential material as it > may be snooped on by interested government parties for unknown > and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 > > > ---------------------------(end of broadcast)--------------- ------------ > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > __________________________________________________________________________ Acabe com aquelas janelinhas que pulam na sua tela. AntiPop-up UOL - É grátis! http://antipopup.uol.com.br/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
