1,112 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
69
views
How to achieve dynamic partition pruning in BigQuery TVF using a subquery lookup?
I have a Table Valued Function (TVF) that takes an array of IDs as input.
source_table: A very large table (TBs) partitioned by day on capturedTimestamp.
selection_table: A small lookup table that ...
Tooling
0
votes
3
replies
48
views
How to enforce dynamic partition pruning in BigQuery TVF using a subquery lookup?
I have a table-valued function (TVF) that takes an array of IDs as input.
source_table: a very large table (TBs) partitioned by day on capturedTimestamp
selection_table: a small lookup table that ...
3
votes
2
answers
226
views
Postgres move partition to archive table
I have a main prod table which I am converting to partitions and am taking a deep dive into Postgres (v14) partitioning on an isolated test system.
On the test system I have two schemas a production ...
2
votes
0
answers
126
views
MySQL 8.4 partitioning not using indexes very well on table
I'm working within a Laravel 12 project running MySQL 8.4. I have a table called pingtree_transactions with an anticipated daily upsert count of around 500,000 rows which will hold at least 2 months ...
0
votes
1
answer
119
views
Partitioned Table - Query filtering on partition field
I have a large table which I want to move to a partitioned model. I created the partitioned table, same fields as the original and partioning by a particular timestamp field (by range). I then ...
0
votes
1
answer
58
views
How partition by custom hash function in MySql?
I am trying to create table like this:
CREATE TABLE `my_table` (
`query_id` varchar(255) NOT NULL,
PRIMARY KEY (`query_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
PARTITION BY hash (TO_DAYS(...
0
votes
1
answer
148
views
How to use references to partitioned table in PostgreSQL?
I research declarative partitioning and prepared such query for partitioned table:
create table _my_message
(
id uuid not null,
chat_id uuid constraint _my_message_chat_fkey references _chat,
...
...
0
votes
1
answer
41
views
Does the partitioned table itself contain data with declarative partitioning? [closed]
I research declarative partitioning and prepared such code for it:
Created partitioned table:
create table _my_message
(
id uuid not null,
chat_id uuid constraint _my_message_chat_fkey references ...
0
votes
3
answers
111
views
Oracle Partition in For Loop Select
I need to fetch all rows in a specific partition of a table and print the values to a file.
CREATE OR REPLACE PROCEDURE
WriteRecordToFile
(
mypartition IN VARCHAR2,
myfilename IN VARCHAR2,
...
2
votes
0
answers
56
views
alter table modify option to remove partitioning completely?
Oracle allows easy redefinition of partitioning schemes with the syntax alter table XYZ modify partition by ... which simplifies the task of either converting a non-partitioned table to a partitioned ...
0
votes
0
answers
36
views
Jakarta @Version sql update version error
All entity with @version
During saving, have next error
could not execute statement [Not found 3 param.] [update cons_data.e_fin_form set version=? where id=? and report_type=? and version=?]; SQL [...
1
vote
1
answer
144
views
Why is MIN($column) doing an Index scan instead of seeking to min value?
I have a table with more than a billion rows, with one of the column definitions being:
row_id int NOT NULL
And an index on it
CREATE NONCLUSTERED INDEX row_id_IX ON dbo.test_table ( row_id ASC ) ...
0
votes
1
answer
53
views
Is partitioning the correct feature for periodical deletions in large tables?
If I have two tables in a (Oracle) database that keeps an history of records through time :
CREATE TABLE Records(
RecordPackId NUMBER,
RecordId NUMBER,
Data VARCHAR2(4000),
PRIMARY KEY ...
-1
votes
1
answer
149
views
Respect existing partitions and not create new
We have an existing database and a DACPAC-based deployment procedure to send it schema updates at deploy time. The database has an existing partition function and existing partition schemes, and the ...
0
votes
1
answer
145
views
automatic table partition when data insert
I have table which is contained list partition in postgres database
create table test(id int, name character varying) partition by list(id);
when I insert data, it is throwing an error.
insert into ...