All Questions
2 questions
0
votes
1
answer
530
views
How to optimize Oracle create table function for a table having over 30 million rows and 250 columns
I need to create a table which has over 30 million rows and about 250 columns from another table which has same row number and about 230 columns. It is like ETL process. I use SPSS Modeler to run a ...
- 1
2
votes
2
answers
226
views
MySQL Partitioning: SELECT by ID, but DELETE by date
Consider the following table:
CREATE TABLE `event` (
`uid` bigint(13) NOT NULL,
`time` bigint(14) NOT NULL,
`type` smallint(5) NOT NULL,
`msg` varchar(2048) DEFAULT NULL,
KEY `uid` (`uid`),
...
- 21