I have a partitioned table where data resides only in the child tables. The master table has an insert trigger that will distribute inserted data into appropriate child tables.
Now, I need to create ...

I have a system that inserts several million records over the course of 24 hours. Users don't care about the data that's older than 24 hours, and typically query data over a small time frame (5 to 60 ...

I have a requirement to partition quick growing tables in our product and below are the table information with key details.
PERIODIC_EVENTS (PARENT TABLE which has ID (sequence no) as Primary KEY and ...

I may be overthinking this but:
I have an API; I want to log calls to the API for stat/debugging purposes. Ideally the speed of reads should be quick but is not essential (as will primarily be read ...

I have a table where data is archived. I need to keep this data as it is rarely viewed.
Instead of moving archived data to a separate table, I wanted to create a partition on the Archived field. When ...

Our incident management system has run for years, and the large quantity of closed incident tickets makes the table rather huge and slows down the search queries.
Our database version is oracle 11g ...

I am using Oracle 11g database and I have 45 million records. I want to partition the table, but if it's possible for partitioning to support the like operator then it will be much helpful for me.
In ...

I have a SQL Server table with 42 million + records. This table acts as a staging area for transaction records loaded from a different system. Data from this staging table have to be transformed and ...

I run an application (price comparison website) where I need to update a pricing table with dozens of millions of rows every day.
Basically, every product feed I download from a merchant results in ...

I'm writing a powershell to create a duplicate table(in another schema) for the purposes of partition switching*. I'm having problems adding the columns and the clustered column store index.
Here's ...

I have a big table (>100 million rows) that tracks user's activities. It has an ID, which is PK and has auto_increment property. This is the only unique key. Table also has userid and datetime column.
...

I have data with a timestamp field of the form '2014-01-01 00:00:00.99' in one of the columns. I want to create a new partition for the table every month. For this I did something like this.
CREATE ...

Since I'm a young developer and not really skilled in using databases (PostgreSQL 9.3) I ran into some problems with a project, where I really need help with.
My project is about collecting data of ...

I have recently converted our one large table to use table partitioning in SQL Server 2012.
It's a table that stores logs based on a time. So I created a partition function to split the table on my ...