Re: [PERFORM] Join method influences scan method?

2005-03-16 Thread Tom Lane
[EMAIL PROTECTED] writes: > So, it would seem like my optimal plan should have hash joins with index > scans. No. The thing you are looking at here is a nestloop join with inner index scan, which has to be understood as a unit even though EXPLAIN doesn't describe it that way. The inner indexscan

[PERFORM] Join method influences scan method?

2005-03-16 Thread mark . lubratt
This apparently didn't go through the first time; so, I'm reposting... - Hello! First off, I'm running 8.0.1 on Win2000 Server. Vacuum analyze is done every night. Query cost parameters are standard, I've only