All Questions
34,556 questions
1
vote
5
answers
145
views
How do I index in R so that my data isn't deleted when there are no indices?
I would like to be able to use indices in R so that if there are no indices that meet the criteria, the data is not deleted. For example, the following code doesn't recognize that I want to keep the ...
- 1,253
Tooling
0
votes
1
replies
18
views
API that provides a list of stock names given a sector name
I'm looking for an API that given a sector name, provides a list of stock names.
- 81
-3
votes
2
answers
91
views
Index name in Oracle
In my app I'm running these SQL queries:
SELECT 1
FROM all_indexes
WHERE table_name = UPPER('my table name')
AND table_index = UPPER('my index name')
CREATE INDEX my index name ON my table name(...
- 6,492
2
votes
1
answer
45
views
Sort a Lucene index by a StoredField or a function of docID
I have a lot of static (unchanging) Lucene indexes where each document has been given an integer StoredField called "fileId" (and each index only has 1 segment). I now want to modify these ...
- 33
3
votes
1
answer
148
views
Why does my 2D Vector of C strings not output the element at the given index? [duplicate]
Technically its a vector<vector<vector<const char *>>> but I'm using it as a vector<vector<cstrings>>
I have been stuck at this issue for weeks and I do not understand it....
- 33
Advice
1
vote
6
replies
110
views
How do I get specific values from specific keys in a dictionary?
I have made a dictionary and a list of dictionaries, but I am not sure how to get specific data from the different forms. I tried using '.startswith('7'), but it always gives me an error. I want to ...
1
vote
2
answers
96
views
Index array without assigning it to parameter
I have to split a string and use a part of it for further processing. So the idea is:
string='aaa-bbb-ccc-ddd'
parts=(${(@s:-:)string})
print -- $parts[3]
# ccc
I would like to refactor the second ...
- 5,551
0
votes
0
answers
179
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.3k
4
votes
1
answer
126
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 ...
1
vote
1
answer
69
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
108
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,257
1
vote
1
answer
108
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
44
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
105
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
38
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\...
- 429