Top "Indexing" questions

PostgreSQL LIKE query performance variations

I have been seeing quite a large variation in response times regarding LIKE queries to a particular table in my …

postgresql indexing pattern-matching query-optimization sql-like

Can I do a MongoDB "starts with" query on an indexed subdocument field?

I'm trying to find documents where a field starts with a value. Table scans are disabled using notablescan. This works: …

regex mongodb search indexing full-table-scan

Python: Object does not support indexing

Yes, this question has been asked before. No, none of the answers I read could fix the problem I have. …

python object indexing typeerror

Can PostgreSQL index array columns?

I can't find a definite answer to this question in the documentation. If a column is an array type, will …

arrays postgresql indexing

Cannot create index on view 'View_Table_Name' because the view is not schema bound

I am using Views in my stored Procedure(SQL-Server). For Improving Performance, I have tried to created INDEX of that …

sql-server tsql view indexing

Create an index on a huge MySQL production table without table locking

I need to create an index on a ~5M rows MySQL table. It is a production table, and I fear …

mysql indexing production alter-table table-locking

What is the use of "multiValued" field type in Solr?

I'm new to Apache Solr. Even after reading the documentation part, I'm finding it difficult to clearly understand the functionality …

indexing full-text-search solr multivalue

How does lucene index documents?

I read some document about Lucene; also I read the document in this link (http://lucene.sourceforge.net/talks/pisa). …

algorithm indexing lucene

Easiest way to check for an index or a key in an array?

Using: set -o nounset Having an indexed array like: myArray=( "red" "black" "blue" ) What is the shortest way to check …

arrays bash indexing key

Oracle - Select where field has lowercase characters

I have a table, users, in an Oracle 9.2.0.6 database. Two of the fields are varchar - last_name and first_…

sql oracle select indexing case-sensitive