Questions tagged [query-analyzer]
74 questions
1
vote
2 answers
Why is Sort operation before Nested Loops (Inner Join)?
I have 2 Sql Server instances, and one query:
SELECT
[DetailDescription],
[SubTotal]
FROM [dbo].[CRR] WITH (INDEX (IX_CORM_CORMId))
WHERE CORM_CORMId >= 5933168 AND CORM_CORMId <= 5955843
This leads to 2 query execution plans:
Here is…
Vladislav Kostenko
- 1,155
- 11
- 18
1
vote
1 answer
Custom analyzer with large char_filter list creation for elasticsearch
I try to add custom analyzer to elastic search. I got a too large "mappings" list of synonyms (mapper_list). Size of mapper_list is about 30.000 elements.
requests.post(es_host + '/_close')
settings = {
"settings" : {
"analysis" : {
…
jjj41
- 33
- 2
1
vote
1 answer
ElasticSearch search for special characters with pattern analyzer
I'm currently using a custom analyzer with the tokenizer set to be the pattern (\W|_)+ So so each term is only letters and split on any non letter. As an example I have a document with the contents [dbo].[Material_Get] and another with…
Nived
- 1,804
- 1
- 15
- 29
1
vote
3 answers
SQL Server 2000: Server memory / CPU parameters in Query Analyzer
SQL Server 2000: Is there a way to find out server memory / CPU parameters in Query Analyzer?
Marek
1
vote
1 answer
How to make elasticsearch disregard spaces between certain queries?
My elasticsearch documents have a field Name with entries like:
Samsung Galaxy S3
Samsung Galaxy Ace Duos 3
Samsung Galaxy Duos 3
Samsung Galaxy S2
Samsung Galaxy S (I9000)
On querying this field with the following query (notice the space between…
Souri
- 15
- 3
1
vote
1 answer
Save Field Names in Microsoft SQL Query Analyzer
When you save the results of a SQL query using "Microsoft SQL Query Analyzer" (version 8), the results of the query are saved but the column headers (field names) are not. Any idea how to save the field names to the results file as well?
Michael Shnitzer
- 2,465
- 6
- 25
- 34
1
vote
2 answers
ElasticSearch search_analyzer applied but no result returned
I have a query that should search for lowercase terms.
Actually I just had a index_analyzer with a lowercase filter, but I wanted to add also a search_analyzer so I could do case-insensitive searches.
"analysis": {
"analyzer" : {
…
Kamafeather
- 8,663
- 14
- 69
- 99
1
vote
1 answer
Hibernate Search with AnalyzerDiscriminator - Analyzer called only when creating Entity?
can you help me?
I am implementing Hibernate Search, to retrieve results for a global search on a localized website (portuguese and english content)
To do this, I have followed the steps indicated on the Hibernate Search…
Eduardo Mendes
- 77
- 8
1
vote
3 answers
Must-have features for F/OSS SQL analyzer/optimizer
I like MySQL's Query Analyzer...but not the price tag. I think I can write something myself to do analysis on slow query logs, indexes, table status fields, etc. and offer it as an alternative, F/OSS solution.
What would be your top-requested…
AJ.
- 27,586
- 18
- 84
- 94
1
vote
1 answer
elastic: search with unnecessary words
please show me the right direction :)
I've a task: find documents in elastic search by query, which may contain unnecessary words.
I'll show what I mean:
assume that I have some document which contains words "big red car" (now they are in different…
Sergey Lobin
- 11
- 1
1
vote
1 answer
solr query analyzer underscore
I have underscore separated and camel case values ( eq "SimplyShopping_Rediff") in the field of the document with fieldtype as text_ws.
…
Deepak
- 490
- 4
- 11
1
vote
3 answers
Is it possible to modify the default SQL in query analyzer for 'edit top 200 rows'?
What if I want to edit the bottom 200 rows, or a custom query, is this possible?
loyalflow
- 14,275
- 27
- 107
- 168
1
vote
0 answers
Clearing Dirty Pages with Checkpoint, and getting results from MemoryStatus
Warning: I'm a generalist, and what I know about configuring SQL server you could gather up and put in your belly button, and the lint wouldn't be displaced. Mostly, I can write queries to get what I need. Unfortunately, I'm also responsible for…
Julie
- 353
- 1
- 8
- 17
1
vote
2 answers
How to force solr QParserPlugin not to use whitespace tokenizer for Keyword fields?
I have keyword field in Solr schema.
When I try to search this field with…
yura
- 14,489
- 21
- 77
- 126
0
votes
0 answers
Tips for Identifying Query Patterns and Creating REST Endpoints for a Database Wrapper Microservice
We're trying to move some direct access to our team's database by some internal teams behind a microservice.
We've collected sample queries to find common patterns for REST endpoints, but it's turning out to be a bit tougher than we originally…
