Stack Overflow
Stack Overflow

Questions tagged [query-analyzer]

74 questions
0
votes
1 answer

Postgres query cost is higher but runs faster

Update on 2022-05-15 After running vacuum analyze, the query plans are below. For A query Nested Loop Left Join (cost=45913.11..496597.16 rows=10 width=128) (actual time=115.205..3068.596 rows=10 loops=1) Join Filter: (project.uuid =…
pjr
  • 37
  • 9
0
votes
1 answer

filters effect on search results in solr

when i query for "elegant" in solr i get results for "elegance" too. I used these filters for index…
Romi
  • 4,833
  • 28
  • 81
  • 113
0
votes
1 answer

creating settings of index using elastic4s

I have some class: class SomeClass(val client: ElasticClient, val config: Config, val configName: String)(implicit val ec: ExecutionContext) extends ElasticSearchRepositoryWrapper[AnotherClass]{ override def mapping:…
Murat Kenesbayev
  • 15
  • 5
0
votes
0 answers

Elasticsearch auto look up query

I need some help with the below problem statement Problem is to implement auto look up functionality with below mentioned requirement Input -> BTech Output -> BTech in cse b.tech in computer science b tech in computer Input -> B.Tech Output -> …
pankaj
  • 1,643
  • 4
  • 22
  • 35
0
votes
0 answers

SQL Server implicitly converting date-like VARCHAR to datetime

I have a column in a table named Foo called Bar. It's defined as a varchar(10) not null. The content of that column for the record I am looking at is Jan 1 1900 12:00AM -- remember, this is a varchar(10), not a datetime. But when I do a SQL…
Gus Mueller
  • 185
  • 10
0
votes
1 answer

SQL Server profiler trace not showing parameter values

I've searched for solutions on this but haven't found anything that works for me yet. I'm successfully using SQL Server Profiler to trace my calls to procedures and queries for one instance of SQL Server. It's very handy because I can see the calls…
user2026318
  • 173
  • 1
  • 13
0
votes
1 answer

What happens when the top-k query does not find enough documents to satisfy k constraint?

I am evaluating the top-k range query using NDCG. Given a spatial area and a query keyword, my top-k range query must return k documents in the given area that are textual relevant to the query keyword. In my scenario, the range query usually finds…
João Almeida
  • 45
  • 1
  • 1
  • 8
0
votes
1 answer

How to heavily weight exact query text in solr rather than results containing it as a substring?

I'm working with name searching and, for some reason, when I query "sam" documents containing the query as a sub-string like "samara", "samir", or "samuel" are returned with seemingly equal weight. Is this just a built-in feature of Solr to parse…
muZero
  • 948
  • 9
  • 22
0
votes
1 answer

How to interpret Solr Admin Analysis screen

I'm reading the docs on the analyzer screen of the Solr Admin, but I'm still not sure how to determine when a given query matches with something-- is this when it is shaded light blue after a step in its analyzer chain? Also is there a way to see…
muZero
  • 948
  • 9
  • 22
0
votes
2 answers

SQL Query Analyzer: How can I check database compatability mode?

How can I check database compatability mode in query analyzer version 8?
bizness
  • 55
  • 2
0
votes
1 answer

SQL server management studio 2014 setting only returns whole numbers

Does anyone know if there is a setting within the app itself that would cause it to only return whole numbers? Example - query is set up to return data 123456789.26 but is being rounded to a whole number 123456789 I cannot find any settings or…
Fobara
  • 3
  • 2
0
votes
1 answer

How to reduce number of identical queries when retrieving records in model

I have started using query-analyzer and it's warning me about identical queries. For context, I am loading 25 "posts" on the page, and the current user can "star" a post: 0.018s 25 identical queries SELECT SQL_NO_CACHE N AS one FROM 'stars' WHERE…
Jody Heavener
  • 2,704
  • 5
  • 41
  • 70
0
votes
0 answers

Elasticsearch. SKU analyze and search

It makes me mad already, I've tried everything I can with this. Here is the thing. I need to: transform all similar looking russian letters to english (while analyzing and search requests) remove all non-alphabetical and non-digits make tokens…
Ivan Shamatov
  • 1,406
  • 1
  • 10
  • 17
0
votes
1 answer

Custom analyzer with lowercase filter doesn't work as expected

I have a simple custom analyzer called custom_raw_analyzer like this: $ curl 'http://localhost:9200/test/_settings?pretty' "test" : { "settings" : { "index" : { "uuid" : "_M-KXnZSQXyFH7cqbh6lsw", "number_of_replicas" :…
fang
  • 617
  • 6
  • 17
0
votes
2 answers

query for extracting values from a column containing data in XML format

suppose I have a table, mydata, that has a column xmldata whose values are text in XML format such as 123 how do I…
user571099
  • 1,491
  • 6
  • 24
  • 42
1 2 3
4
5