When you click the Generate View button, a PL/SQL program creates SQL queries for user criteria that directly reflect your input on the A.60.06 screen. Because this program can only handle the syntactic issues involved in query translation, query results often exhibit poor performance due to unnecessary, complex user criteria resulting from unnecessary, complex SQL queries. This chapter describes common query problems and how to avoid them.