Re: Stored procedure - variabile per creazione tabella
Grazie ancora
ho dato un pò una lettura, e teoricamente a me serverebbe una partizione by range, del tipo
PARTITION BY RANGE(YEAR(TimeLog)) (
PARTITION p0 VALUES LESS THAN (2014) ENGINE = MyISAM,
PARTITION p1 VALUES LESS THAN (2015) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (2016) ENGINE = MyISAM,
PARTITION p3 VALUES LESS THAN (2017) ENGINE = MyISAM,
PARTITION p4 VALUES LESS THAN MAXVALUE ENGINE = MyISAM
)
;
Subject
Views
Written By
Posted
1025
November 10, 2018 01:54PM
572
November 12, 2018 06:08AM
562
November 12, 2018 08:07AM
561
November 12, 2018 08:58AM
Re: Stored procedure - variabile per creazione tabella
429
November 12, 2018 10:17AM
515
November 13, 2018 05:44AM
582
November 14, 2018 04:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.