daniel56hdz

3 ms·

1. 1.▲
   by daniel56hdz 3y ago

   Could you please expand on this more? I could really use the understanding!
2. 2.▲
   by daniel56hdz 3y ago

   Yes these tables have indices but it doesn’t mean much once we try to find the earliest dateTime for each device using a group by.
3. 3.▲
   by daniel56hdz 3y ago

   Yes, the significance of the “specific_date_time_value” is that certain users will want to query based on that to determine if it’s a device that they should remediate. A large percent of the queries though would be based on now() vs a spec
4. 4.▲
   Help on database for efficient group bys

   1 points by daniel56hdz 3y ago|6 comments