For questions about making database queries run faster.
I've been battling this one for a while now. I have a stored proc that takes in 3 parameters that are …
sql-server tsql query-optimization case where-clauseI have a Sqlite database which I want to check the indexes are correct. MS SQL Analyser is great at …
sql sqlite query-optimization sql-execution-planWe have a query to remove some rows from the table based on an id field (primary key). It is …
sql database sybase query-optimization database-optimizationif it's known that there are only two values to candidate for the result of a column, ifnull(a, b) …
mysql query-optimizationI'm trying to understand how no_index actually speeds up a query and haven't been able to find documentation online …
oracle query-optimization hintI have the following table and indices defined: CREATE TABLE ticket ( wid bigint NOT NULL DEFAULT nextval('tickets_id_seq'::…
postgresql indexing query-optimization database-partitioning postgresql-performanceI remember reading somewhere that the mongo engine was more confortable when the entire structure of a document was already …
mongodb optimization query-optimization nosqlI ran a query in Mysql like below: EXPLAIN SELECT * FROM( SELECT * # Select Number 2 FROM post WHERE parentid = 13 ORDER BY …
mysql sql indexing query-optimization explainI have a table User with a bunch of indexes. One of them is a unique index on the AccountIdentifier …
sql sql-server query-optimization sql-execution-planI want to consult SQL Server OR short-circuit Code: DECLARE @tempTable table ( id int ) INSERT @tempTable(id) values(1) DECLARE @id …
sql-server tsql query-optimization short-circuiting