Probably the only valid reason for using
set enable_seqscan=false
is when you're writing queries and want to quickly see what the query plan would actually be were there large amounts of data in the table(s).
The order the container uses in building the chain of filters to be applied for a particular request URI is as follows:
First, the <url-pattern> matching filter mappings in the same order that these elements appear in the deployment descriptor.
Next, the <servlet-name> matching filter mappings in the same order that these elements appear in the deployment descriptor.
M. Winkler, J. Spillner, and A. Schill. Service-Oriented Computing, volume 5900 of Lecture Notes in Computer Science, Springer Berlin Heidelberg, (2009)
R. Dijkman, and P. Gorp. Business Process Modeling Notation, volume 67 of Lecture Notes in Business Information Processing, Springer Berlin Heidelberg, (2011)
S. Maxwell III. Proceedings of the 1994 IEEE World Congress on
Computational Intelligence, 1, page 413--417a. Orlando, Florida, USA, IEEE Press, (27-29 June 1994)