query: What are indexes and how can I use them to optimize queries in my database?
positive_passages.docid: 20729
positive_passages.text: What is an index in SQL?
negative_passages.docid: 5073
negative_passages.text: How can I force MySQL to IGNORE ALL indexes?
negative_passages.docid: 141641
negative_passages.text: php/mysql with multiple queries
negative_passages.docid: 28484
negative_passages.text: SQL Server indexes - ascending or descending, what difference does it make?
negative_passages.docid: 153847
negative_passages.text: How can i optimize MySQL's ORDER BY RAND() function?
negative_passages.docid: 151841
negative_passages.text: Improve Query Performance over Large Dataset
negative_passages.docid: 52984
negative_passages.text: How can I better optimize my tables and a LEFT JOIN query to find items that don't yet exist in the right table?
negative_passages.docid: 8316
negative_passages.text: Do frequent DML operations on a table with indexes and huge data affect SELECT query performance?
negative_passages.docid: 131872
negative_passages.text: Search for all occurrences of a string in a mysql database
negative_passages.docid: 116637
negative_passages.text: When should I rebuild indexes?
negative_passages.docid: 113492
negative_passages.text: Do indexes work with "IN" clause
negative_passages.docid: 33417
negative_passages.text: Tune a simple inner join query
negative_passages.docid: 108471
negative_passages.text: Multiple indexes for a Java Collection - most basic solution?
negative_passages.docid: 99544
negative_passages.text: postgres: index to SELECT strings like '%foo%';
negative_passages.docid: 5515
negative_passages.text: Benefits of using backtick (`) in MySQL queries?
negative_passages.docid: 113750
negative_passages.text: When should I use a unique constraint instead of a unique index?
negative_passages.docid: 127553
negative_passages.text: Why is this MySQL SELECT performing so slowly despite indexing?