Questions tagged [indexing]
Indexing data structures is a general technique to improve the speed of data lookups.
indexing
34,446
questions
1
vote
1
answer
25
views
Python Pandas difference in boolean indexing between ~ != and ==
I am confused about different results of boolean indexing when using ~ after != versus when using just ==
I have a pandas df with 4 columns:
dic = {
"a": [1,1,1,0,0,1,1],
"b&...
- 25
0
votes
0
answers
16
views
filtered special Database statements for google index
I have the url() statement in my database. all in www.site.com/random_alias format (splash pages).
Some links were created by the admin (userid=1) and archived to specialized (archived=1).
how can I ...
- 11
0
votes
1
answer
34
views
Create a new column based on other columns for time series data in pandas
I have the following pandas dataframe with columns May, June, and July.
Month
June
July
Aug
June
a
d
g
July
b
e
h
Aug
c
f
i
I want to create a several new columns with a 1 month forecast, 2 month ...
- 1
0
votes
1
answer
27
views
How to Handle Indexes for @MapsId in JPA: Should FK and PK Share the Same Index?
I am using the @MapsId annotation in JPA to map a foreign key (FK) to a primary key (PK). According to the @MapsId annotation, the FK and PK share the same value. However, when I checked the database ...
- 121
0
votes
0
answers
24
views
PostgreSQL not using index on materialized view
I've got a materialized view which has 2 columns (patient_id BIGINT, department_ids TEXT[]).
It is a handy precomputed dataset used to filter patients who have received care in a hospital department ...
- 309
-2
votes
1
answer
53
views
get index of first character in a string, out of five correct characters, in one line [closed]
I'm trying to compress my code (least lines and characters challenge with a friend), and I've run into a problem.
outputWord = ""
def translate(inp):
output = []
words = inp.split()
...
- 5
-1
votes
1
answer
65
views
Does database compound index order matter if the first column is only queried with an equal operation?
Question: assuming I have an Orders table with an index (UserId, CreatedTime), does it matter if I add DESC to CreatedTime if I want to list orders by a single user only?
For example:
SELECT *
FROM ...
- 19.8k
1
vote
2
answers
52
views
How to Optimize Search Queries on a Large PostgreSQL Table without Compound Indexes?
I have a PostgreSQL table named users which contains between 20 to 30 million records. The table has the following columns: id, tenant_id, name, company, location, and description.
I need to perform ...
- 39
-1
votes
0
answers
15
views
Google search engine indexing very differently for two similar searches - abc.com v/s abc [closed]
GOOGLE SEARCH ENGINE CRAWLING AND INDEXING query --
Hello guys, I have recently taken a website live and the organic footfall is less. Now when I search myDummyWebsite.uk in google search I get back ...
- 1
1
vote
1
answer
25
views
Optomize query for postgresql with index on jsonb array
I have tables:
request(id: int, current_stage_id: int, selection_id: int)
selection(id: int, settings: jsonb)
Settings has array like {id: int, stage_type: int}.
For example: [{id: 1, stage_type: 2},...
- 71
0
votes
0
answers
10
views
OR logic for multiple fields in indexedDB with pagination
IndexedDB beginner. I have an objectStore with objects having fields f1, f2 and f3. I want to search on this objectStore using values v1 and v2 using the following condition:
(f1==v1 OR f2==v1) AND (...
- 334
2
votes
1
answer
48
views
Unique partial indexes in PostgreSQL
I have a table (table_a) with columns: id, column_b, column_c, column_d, and archived. The id column is the primary key. The combination of column_b and column_c should be unique when archived = 0. If ...
0
votes
1
answer
43
views
Azure Search Index VIA .NET Core console app, over-writes old document
I am adding documents to Azure Search Index VIA .NET Core console app. When I am adding new documents it over-writes the old document and finally index has only one document.
I am using ...
-5
votes
1
answer
57
views
Dictionary Update Stops at Index 35
I'm trying to iterate through a list (config_patterns) and add each element as a key to a dictionary (predefined_patterns) with a value of 0. There are 40 elements in this list. However, the final ...
- 7
-1
votes
2
answers
70
views
Searching for an Integer with the highest index within a string - C#
String[] digits = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" };
String line = "...
