IMHO, ...id=(select user) yields a better explain.
"with a WHERE clause of WHERE user id=USER."
Attachments
Library
Quick Reference
Archives
Sample Index
2002 Indexes