Questions tagged [table-partitioning]
47 questions
0
votes
1 answer
record "new" is not assigned yet
I'm trying to implement table partition and I have the below code in PostgreSQL (source from https://www.postgresql.org/docs/9.6/ddl-partitioning.html )
CREATE or replace FUNCTION child_tables.func_inventory_movement_insert_trigger()
RETURNS…
Rj_N
- 192
- 1
- 10
0
votes
1 answer
Execution plan showing missing non-clustered index on already partitioned clustered indexes
We have a query where the table is partitioned on column Adate.
Row count: 56595943, partition scheme - yearly, no of partitions - 300
Clustered index columns : empid, Adate
Query :
select top 1 Adate
from emp
where empid = 134556 and Adate <= {ts…
IvoryYagami
- 3
- 1