13 questions with no answers
0
votes
0
answers
64
views
Optimizing MySQL LIKE Query with Pattern Matching for Large Data(20M+ records) and FULL TEXT SEARCH not giving accurate results
Optimizing MySQL LIKE Query with Pattern Matching for Large Dataset (20M+ records)
I'm struggling with performance issues in MySQL while searching through a large table containing over 20 million ...
- 11
0
votes
0
answers
438
views
SQL Script looking for missing indexes is showing some existing indexes
I have the following SQL script to use for our Microsoft Dynamics NAV Database (MS SQL Server). It looks for missing indexes in the database. We have the problem that the script also finds some tables ...
0
votes
0
answers
346
views
How to avoid PL/pgSQL loops? What are performance alternatives?
I have close to 200M records in my tables. My migration script runs very slowly (for hours).
---My OLD Tables---
orders_old table 30M row count
id
createdDate
status
price
1000376453
2021-10-14
...
- 706
0
votes
0
answers
347
views
slow performance of update statistics if iterating over several statistics of a table instead of updating all statistics
maybe someone here can help me - I'm pretty stuck:
Today I started building a SSIS package, which should take over the task of evaluating the statistics of numerous tables and perform an update on ...
- 3,222
0
votes
0
answers
346
views
Individual table cost reduces, overall query cost increases
I'm trying to optimize a huge MySQL database, while doing that I'm looking into adding indexes to the table columns. Here I am noticing a strange behavior, when I add the index to the particular ...
- 10.7k
1
vote
0
answers
15
views
Querying a table several times over querying the table once in a tmp table and querying that subset
I have a stored proc which queries this one table (have clustered index on it) several times to get the count and sum of various fields in that table. I am thinking of ways to optimize this stored ...
1
vote
0
answers
55
views
Is there a way to count time spent on `waiting for query cache` in MySQL?
As part of optimization, I'm trying to determine how much time is spent during waiting for query cache step. Is it possible to get such an aggregated value?
- 3,401