Hi all, I'm having problems with a query that's just "stalling" my database. If someone could help me out - I posted a forum topic on http://forums.devshed.com/postgresql-help-21/postgresql-new-index-pros-and-cons-467120.html There's just this one integer field, which when searched on, "stalls" my query and I don't get any results. I tried adding an index to that integer, but that didn't seem to help.. Please let me know if there's any solution to this. Any help would be really appreciated! Many thanks! ____________________________________________________________________________________Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend