Stack Overflow
Stack Overflow

Questions tagged [query-analyzer]

74 questions
2
votes
2 answers

How can I analyze Django ORM query performance on a server with DRF Endpoints only?

Previous Django apps I've worked on have used HTML template rendering, and django-debug-toolbar has proven to be a valuable way to analyze ORM SQL queries and find places to optimize. The current app I'm working on uses Django for…
Glenn Barnett
  • 2,031
  • 1
  • 21
  • 31
2
votes
1 answer

How to Configure MySQL for Percona Monitoring and Management

I can not get any analytics from _PMM Query Analytics showing https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html this is that link. I changed the configuration as mentioned in this page, but after that pmm is not…
AATHITH RAJENDRAN
  • 4,689
  • 8
  • 34
  • 58
2
votes
1 answer

How to stop Lucene Standard Analyzer removing special characters

I have been having some difficulty with Lucene and would appreciate any help. I have a custom query which is manually written and parsed (this query) using QueryParser.Parse. I am using version LUCENE_29 and the StandardAnalyzer. In my query I have…
H S
  • 103
  • 13
2
votes
2 answers

Export to excel from SQL Server 2000 using Query Analyzer code

What's the easiest way to export data to excel from SQL Server 2000. I want to do this from commands I can type into query analyzer. I want the column names to appear in row 1.
cindi
  • 4,571
  • 8
  • 31
  • 38
2
votes
2 answers

Lucene. index a few tokens for each word in the text

I'm using lucene 3.5 with SpanishAnalyzer (that itself uses SpanishStemmer and StandardTokenizer). When SpanishAnalyzer index a document with the words (for example) "claramente" and "claro", they will be both indexed as "clar". This behavior is…
Ron K
  • 109
  • 1
  • 9
2
votes
2 answers

SQL Server 2000, Do queries executed sequentially?

I am not sure if my question is related with the tool for executing the queries. (I am using Query Analyser, Access and AQT generally). For example I have two queries. SELECT * FROM Table1 SELECT * FROM Table2 So, do the queries executed…
stckvrflw
  • 1,489
  • 3
  • 22
  • 37
2
votes
3 answers

Updating long string through SQL Server Query Analyzer

I have a really long string of text that I would like to update a particular column in a table. The update statement in sql query analyzer is on one long line currently. Is there a way to break up the update statment into multiple lines for easier…
Joo Park
  • 3,115
  • 4
  • 27
  • 31
1
vote
1 answer

Query analyzer or profiler for SQL Server CE 4

Is there any query analyzer or profiler for Microsoft SQL Server CE 4?
Ghooti Farangi
  • 19,926
  • 15
  • 46
  • 61
1
vote
1 answer

Elasticsearch Analyzer first 4 and last 4 characters

With Elasticsearch, I would like to specify a search analyzer where the first 4 characters and last 4 characters are tokenized. For example: supercalifragilisticexpialidocious => ["supe", "ious"] I have had a go with an ngram as follows PUT…
nuvio
  • 2,555
  • 4
  • 32
  • 58
1
vote
1 answer

What does Level and State refer to in Microsoft SQL Server Query Analyzer

I use Query Analyzer all the time and am often greeted by errors where I am told a level and a state but never a line number. Presumably level and state are useful pieces of information, though I have never seen these defined.
Gus Mueller
  • 185
  • 10
1
vote
2 answers

Adding Where clause takes less time in SQL - why?

select count(*) from table takes more time to execute than: select count(*) from table where x = '1' here x is not an index Using where clause, SQL has to do some extra work so why the query having where clause is fast.
jayant singh
  • 929
  • 12
  • 17
1
vote
1 answer

Custom analyzer, use case : zip-code [ElasticSearch]

Let be a set index/type named customers/customer. Each document of this set has a zip-code as property. Basically, a zip-code can be like: String-String (ex : 8907-1009) String String (ex : 211-20) String (ex : 30200) I'd like to set my index…
Simba
  • 51
  • 1
  • 6
1
vote
2 answers

Can we use Google Translate API to index files for searching?

I am using Lucene 4.2.1 to index files. I need to index multilingual content for which we use Analyzer based on the language, to tokenize and index keywords. However Lucene 4.2.1 does not have analyzers for some languages like Japanese, Korean. The…
Mihir Thuse
  • 11
  • 2
1
vote
0 answers

Postgresql bad query plan with some parameters

I have a query on a large table that lasts from 2 seconds to 3 minutes depending on a parameter. Is there a way to tell to Postgres (9.6) that its query plan is sometimes very bad ? Explanations I have two tables: Table "public.ItemUpdates" …
Amoki
  • 31
  • 4
1
vote
1 answer

Unable to Refresh PowerBI Analyze in Excel

I have installed the PowerBI "Analyze in Excel Updates" and "PowerBI Publisher for Excel". Every time I refresh the OLAP Cube it asks for login credentials. I am sure the login credentials are correct as I am using the same to log in to PowerBI…
Rahul Gohrani
  • 37
  • 1
  • 1
  • 3
1
2
3 4 5