34,564 questions
0
votes
0
answers
93
views
How to use index in simple select
Table has index on name column:
CREATE TABLE firma2.klient
(
kood character(12) primary key,
nimi character(100),
...
);
CREATE INDEX IF NOT EXISTS ...
- 28.2k
0
votes
1
answer
92
views
Unique filtered index claims there is a duplicate, but there is not
I have an unique filtered index that is not allowing a PO to be inserted and there is no duplicate to be found.
How can I allow POs to be inserted that are unique when the index thinks they are ...
3
votes
1
answer
101
views
Trying to populate a list from another sheet by a single reference number
I am working on a handy reference sheet for my DnD Games, that includes 10 pre-planned encounters of varying difficulty that I want to reference on an Initiative Sheet by referencing the Encounter ...
-7
votes
0
answers
68
views
Acessing index by id. JAVA [closed]
How Output do I access the element index/id in the right way? Because I put 101 and it goes to 102 then I fixed it I put -1 on the scanner, then when I put 101 it access 100.
Please help
System.out....
- 1
0
votes
1
answer
58
views
AWS Glue Script Scanning Entire Table Despite Date Filter
I have written a small Glue script that fetches some data between two dates, but I found that it scans the entire table instead of just the data within the specified time range. I also tried creating ...
Best practices
0
votes
3
replies
99
views
How to access specific, indexed elements of a Pandas Dataframe for math?
What is the right/pythonic way to do math on a few indexed elements in a Pandas Dataframe?
I tried a few ways but they seem awkward and confusing:
df = pd.DataFrame({'x': [1, 2, 3, 4, 5, 6, 7, 9, ]})
...
- 5,247
1
vote
1
answer
80
views
Slow TimescaleDB lookup on indexed column (event_key) without a time filter
I'm using a self-hosted TimescaleDB instance to store logs. I have a hypertable logs that is partitioned by the timestamp column.
I need to perform a fast lookup query based on the event_key column, ...
- 11
Advice
1
vote
1
replies
38
views
Why do B-tree disk optimizations work when the OS controls physical disk layout?
I understand the standard explanation for why B-trees are used in databases: they minimize disk seeks by packing many keys into each node, keeping the tree shallow (3-4 levels), and enabling efficient ...
- 11
Advice
0
votes
6
replies
96
views
Why MariaDB doesn't use newly added index?
MariaDB version is 10.4.34.
The query looks like:
SELECT bet.*
FROM Bet bet
WHERE bet.placed >= '2025-10-29T00:00:00'
AND bet.placed <= '2025-10-29T23:59:59'
AND EXISTS (
SELECT 1 FROM ...
- 18.8k
Advice
0
votes
1
replies
35
views
Why search "vsc" in windows start menu can find out Visual Studio Code?
Windows 10 22H2.
Ask this question because at the same time, type ame can't find out Adobe Media Encoder.
and I don't see vsc.exe defined in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\...
- 409
2
votes
2
answers
61
views
Trouble Faceting on Text Field Terms in Facet Queries
I'm trying to use faceting to look at the terms that were indexed into a field, realizing this is a bit atypical, but I'm using it as a debugging tool. The problem is I'm not seeing any faceted terms....
- 31
2
votes
1
answer
112
views
Does `jax` compilation save runtime memory by recognizing array elements that are duplicated by indexing
Consider the example code:
from functools import partial
from jax import jit
import jax.numpy as jnp
@partial(jit, static_argnums=(0,))
def my_function(n):
idx = jnp.tile(jnp.arange(n, dtype=int)...
- 539
-1
votes
1
answer
132
views
Improve name search performance across FirstName/LastName (Hebrew + English) with paging on 3.1M-row join
I need to speed up a query that lists transactions from BillingInfo joined to site/customer tables. Users filter by CustomerName (first + last). Data volume: BillingInfo ≈ 3.1M rows
CREATE TABLE [dbo]....
- 17
1
vote
2
answers
135
views
Add an Index for Duplicate Values using Power Query
I have a dataset that has duplicate Invoice Number values.
I need help generating an index column ("Occurrences") to count the number of occurrences of the "InvoiceNo".
Any ...
- 13
1
vote
0
answers
119
views
How to specify the name while concurrently removing indexes from database
I have some field in my table for which i need to remove indexing. In the django application, i saw that i could do this using the migrations.RemoveIndexConcurrently() method. However im having ...
- 499
0
votes
2
answers
75
views
Can a partial multikey index in MongoDB index only certain subdocuments of an array?
I have a MongoDB collection with documents containing an array of subdocuments. For example:
{
"_id": 1,
"addresses": [
{ "city": "New York", "...
1
vote
1
answer
96
views
Calculating MultiIndex intersection to a given tolerance in an efficient way
I have two DataFrames, data1 and data2, with 3-level multiindices. The first two levels are floats, and correspond to spatial coordinates (say longitude and latitude). The third level, time, is based ...
- 33
0
votes
2
answers
93
views
Check Active Cells from Multiple Column in Excel Online
I have an excel online sheet that I am building. I have list of projects in a sheet and another sheets contain working hours on each of these projects in each week. What I am looking for is a code ...
- 21
-1
votes
1
answer
67
views
Best way to Index and or Key massive datasets [closed]
I have two tables related to each other, each with roughly 200M records.
CREATE TABLE [dbo].[AS_tblTBCDEF](
[CDEF_SOC_NUM] [numeric](5, 0) NULL,
[CDEF_EFF_DATE] [date] NULL,
[CDEF_TYP_BUS] ...
- 8,502
2
votes
4
answers
99
views
Postgresql stops using filter index
I have a very simple table for a task queue and keep taking records out one by one. If I add the filter_selector after filling/resetting the table, postgresql will use it and run super fast. But if I ...
- 14.3k
0
votes
1
answer
87
views
MongoDB Atlas Search Index Too Slow
I need to search crypto tokens by name (text search), symbol (exact match) or address (prefix match, i.e. return all tokens the address of which starts with the user query). Instead of relying on a ...
- 620
1
vote
1
answer
116
views
How to improve word_similarity query performance in postgresql?
In a project, we are using postgresql v12.11 (updating is sadly not an option at the moment).
Consider the following relations:
document (
id uuid primary key
)
page (
id uuid primary key,
...
- 1,413
1
vote
1
answer
109
views
How to extract a value from a list without getting “length 0” errors? [duplicate]
I’m parsing some JSON data in R and got this structure:
entry <- list("Ontario"="ON", "ON"="13.6")
When I try:
j <- entry["Ontario"]
population ...
- 11
2
votes
2
answers
284
views
MySQL: Writing better compound indexes
I recently came to know about the performance boosting capabilities of using compound indexes or composite keys in mysql through this question of mine Create multi table index/composite key.
After ...
- 2,045
1
vote
1
answer
78
views
SQL - Adding Union All on derived table subquery fetches all rows
Attempting to optimize a portion of a query that is joining two related tables, and getting odd results compared to other queries in the project with similar structures. Here is a very simplified ...
- 11
2
votes
1
answer
69
views
Postgres not using index with varchar_pattern_ops for pattern matching query
I have a query in PostgresSQL accessing a big table using a LIKE clause for pattern matching:
Table "rmx_service_schema.document"
...
- 23
0
votes
1
answer
121
views
Query with WHERE clause on a UNION query results in a table scan without using the indexes
An MS Access query with a WHERE clause on a UNION query results in a table scan without using the indexes.
Example: There is a table like this:
CREATE TABLE tblFigures
(
EntryDate DATETIME,
...
- 63
0
votes
1
answer
94
views
MySQL 8 slow queries on indexed table with WHERE event = ? AND merchant = ? AND created_at >=?
I’m troubleshooting slow queries on MySQL 8 and need advice.
I have a table salla_events (~1M rows). The queries look like this:
SELECT *
FROM salla_events
WHERE event = 'order.created'
AND ...
- 11
2
votes
5
answers
159
views
Find match value VBA on 4 conditions
Can anybody help with this? look at the picture I upload.
I have 2 stores with the same location in column "A" and "G", column "B and I" says condition on location. And ...
- 47
2
votes
3
answers
102
views
MySQL index to use for range tests
I have this index:
create index main_cp_index on catalogue_product(
product_class_id, is_public,
(cast(coalesce(data->>'$."need_tags"', 0) as unsigned)) ASC);
When i'm trying to ...
- 293
0
votes
0
answers
55
views
Netbeans download the whole maven repository not the needed dependencies for a spring boot project
Please help, I want to start using netbeans for developing spring boot projects, but I struggle with how to download and use only the needed maven dependencies via netbeans, not downloading the whole ...
- 127
1
vote
0
answers
29
views
Cannot index const object by known property in TypeScript [duplicate]
I have a complex but well-typed constant object such that no matter what the first and second level keys are, there is always a particular known key at the third level (in the example below, moons). ...
- 2,562
-4
votes
1
answer
82
views
List index function behaving wrongly and keeps setting index to 0 [closed]
pfz0 = ["","centi","milli","micri","nani","pici","femti"] # z for zeta
illion = ["llion","illion"]
a0_ni = ...
1
vote
0
answers
71
views
Using scoring profile with semantic ranker seems to be bugged when using filter
https://learn.microsoft.com/en-us/azure/search/semantic-how-to-enable-scoring-profiles
I've recently tried new preview feature of Azure Search, where I can use Scoring Profile with Semantic Ranker at ...
- 11
3
votes
3
answers
124
views
How do element assignments work with numpy arrays using an array for indexing?
I'm very puzzled by the following behaviour of NumPy when assigning elements to an array using an array as indices. Here is a minimal working example:
import numpy as np
i = np.arange(2,4)
a = np....
- 73
0
votes
0
answers
171
views
Correct design for SQL table in SQLite3: how to optimize substring search?
I am using SQLite3 in C++ where I need to store text data. There are 7 columns in the table. I need to filter data by 7 columns. I need to check for equality of 6 columns to a specific value, and I ...
- 1,349
0
votes
0
answers
44
views
How to determine left and right indices quickly in depth-first ordered implicit binary tree?
Suppose I have a complete, perfect binary tree stored in an array. If I store node data in breadth-first traversal order (Eytzinger order), then if an internal node's index is i, its left and right ...
- 6,346
0
votes
1
answer
31
views
Firestore cardinality vs effective cardinality in Composite Indexing
My question is about indexing and cardinality in Firestore.
I have 3 fields:
owner_id: Thousands of users
domain: Hundreds of domains
category: Only 10 unique one
The composite index, which matches ...
- 21
0
votes
1
answer
88
views
PostgreSQL Force Index Scan
I have a table with below columns in PostgreSQL.
id,
location,
store,
flag1,
flag2
Here id, location, store are contributing to Primary Key. So by default postgreSQL creates an index on it.
I have ...
0
votes
0
answers
31
views
I am trying to create a skill in Azure which should chunk text and embed text and push it to Azure AI search for an indexer. No custom skills allowed
I am not allowed to use custom skills for whatever reason. I am only supposed to use built in skills with Azure.
I need to read .txt files from blob > chunk text > embed text > store on ...
- 21
1
vote
4
answers
82
views
Why the index is not used here?
MySQL version is 8.0.37. I have a table with this index.
mysql> show index from catalogue_product where Key_name='cl_pub_need_tags'\G
*************************** 1. row ***************************
...
- 293
1
vote
1
answer
75
views
How to index the overlaps between two vectors in rust
I've been hunting for what I would hope would be a std function, but can't find it. I'm looking for function or method that gives vector overlaps. So, assuming the two vectors:
let my_vector1 = ["...
- 1,883
1
vote
1
answer
43
views
Need to drop/recreate indexes and primary keys, but both primary and hdr secondary have index page logging turned off
I have a concern when dropping and recreating indexes and primary keys in INFX 12.10.
Both the primary server and HDR secondary server have index page logging and dridxauto set to 0.
Given that the ...
- 13
0
votes
0
answers
65
views
Index reference by None in Python [duplicate]
I am currently trying out slicing a string in Python and was confused about how exactly does Python interpret the term 'None' because it behaves rather conveniently when used but I am not how does it ...
- 11
0
votes
0
answers
55
views
Apache Solr IndexUpgrader fails with java.lang.OutOfMemoryError: Java heap space on Large Index (650 GB)
I'm in the process of upgrading Apache Solr from version 8.6.0 to 9.8.0, and part of this involves upgrading the Lucene index format.
I have a large index directory (~650 GB), and I'm running the ...
0
votes
1
answer
63
views
MySQL fulltext index search with multiple columns
MySQL fulltext index search with multiple columns
MySQL Table - sample_table:
col1
col2
col3
col4
Fulltext index:
Keyname: some_keyname
Columns: col1, col2, col3, col4
Question:
To search for a string ...
- 21
0
votes
4
answers
124
views
Poor performance sorting multiple tables in mysql 8.4
I've been trying to improve my query performance for a days in my db Mysql(8.4) but I'm having performance issues with the follow queries (I tried these both):
SELECT sql_no_cache * FROM infracao....
- 424
1
vote
1
answer
55
views
Optimal index for query by multiple fields from a JSONB column
I have a table in PostgreSQL like this:
CREATE TABLE test (
id BIGSERIAL PRIMARY KEY,
data_discriminator VARCHAR NOT NULL,
created_at TIMESTAMPTZ NOT NULL,
data JSONB ...
- 35
1
vote
0
answers
78
views
Optimizing index Function loading the data - Laravel
i have an index function that loads the data by time i have more rows in my database and i need to get them all but the loading it takes time like 8 seconds for getting 400 rows i have currently and ...
- 21
1
vote
2
answers
93
views
How to force PostgreSQL to use index on joined table column?
I have two index :
player_team_id_index on player(team_id)
team_active_index on team(active)
I want to get all players belonging to an active team.
Query 1
explain analyze
select p.*
from player ...
- 18.5k