Changes between Version 2 and Version 3 of Phase4_Profiling_Optimization


Ignore:
Timestamp:
05/09/26 20:01:35 (2 weeks ago)
Author:
226052
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Phase4_Profiling_Optimization

    v2 v3  
    160160CREATE TABLE rental_2026 PARTITION OF rental
    161161FOR VALUES FROM ('2026-01-01') TO ('2027-01-01');
     162}}}
     163
    162164Потоа податоците се префрлаат од старата табела rental_old во новата партиционирана табела rental.
     165
     166{{{
    163167INSERT INTO rental (rental_id, rental_date, inventory_id, customer_id, return_date, staff_id, last_update)
    164168OVERRIDING SYSTEM VALUE