34,566 questions
2 votes
1 answer
44 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
55 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....
0 votes
0 answers
24 views
How to set up Google Crawlers for a GitHub static Website? [closed]
How do I index a site made in Cayman on GitHub via Google Search? He tells me that he can't index it for me. The domain is GitHub.io. Thank you
0 votes
1 answer
47 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
97 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, ]}) ...
1 vote
1 answer
59 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, ...
Advice
1 vote
1 replies
35 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 ...
Advice
0 votes
6 replies
95 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 ...
Advice
0 votes
1 replies
33 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\...
2 votes
2 answers
54 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....
2 votes
1 answer
89 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)...
-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]....
1 vote
2 answers
120 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 ...
1 vote
0 answers
113 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 ...
0 votes
2 answers
69 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", "...