query: Identical query & instance but other execution plans & performance
positive_passages.docid: 146313
positive_passages.text: Window functions cause awful execution plan when called from a view with external parametrized 'where' clause
negative_passages.docid: 111753
negative_passages.text: UPDATE performance where no data changes
negative_passages.docid: 103235
negative_passages.text: When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
negative_passages.docid: 71416
negative_passages.text: mysql UPDATE statement - overhead for same values?
negative_passages.docid: 36538
negative_passages.text: Counter Cache for a column with conditions?
negative_passages.docid: 42458
negative_passages.text: SQLite .NET performance, how to speed up things?
negative_passages.docid: 93412
negative_passages.text: Why does SQL Server use a better execution plan when I inline the variable?
negative_passages.docid: 72701
negative_passages.text: How to emulate SOQL LIKE matching in Apex?
negative_passages.docid: 154901
negative_passages.text: Simple Linq query has duplicated join against same table?
negative_passages.docid: 49767
negative_passages.text: Script to query multiple instances
negative_passages.docid: 92687
negative_passages.text: Join vs. sub-query
negative_passages.docid: 39136
negative_passages.text: System.QueryException: Non-selective query against large object type (more than 200000 rows)
negative_passages.docid: 66300
negative_passages.text: is there a shorter way to set up queries when filtering results?
negative_passages.docid: 158541
negative_passages.text: Does SOQL query get consumed when querying from an empty set?
negative_passages.docid: 90867
negative_passages.text: The performance impact of using instanceof in Java
negative_passages.docid: 24009
negative_passages.text: How do I bulkify queries for directly or indirectly related records?
negative_passages.docid: 143698
negative_passages.text: Why my sql query run faster than my stored procedure?