Hello

I would like to post a question related to which partitioning I can go for based on the below scenario.

I have 2 tables named table1 and table2. Both the tables are having customer I'd and user id column. The hierarchy is multiple users will come under a customer.

Currently in those tables I have got 55k unique users and all these users are tagged under 17k customers. Volume of data in these tables are 100million respectively.

Now I will be having below queries from the application to access data from these tables.

Q1: select * from table1 where report_date =<input date> and user_I'd in <list of user id > and customer_I'd=<input customer id >

Q2: select * from table1 where user_id in <list of user id> and report _date <input date>

Q3: select * from table2 where customer_id =<input customer id > and user_id in <list of user id >

Q4: select * from table2 where user_id in <list of user id>

Considering this scenario, what would be thr best approach.

For Q 1 and 2. Can I go like table1 range partitioned by report date and locally partitioned index on user Id?

For Q3 and 4, hash partition on customer id and global.index or globally partitioned index on user Id?

Please suggest the best way. Environment is oltp.