venkat971

4 ms·

1. 31.▲
   by venkat971 4mo ago

   Hints are great way to experiment, but should not live in live production queries. From my Oracle database days, we saw many customer workloads where old hints overrode the latest database optimizations. Believe in the optimizer's own
2. 32.▲
   by venkat971 4mo ago

   Associating drop table to scalabe delete is not a good framing. These are two different things, and very sensitive on production workloads if there are FK and MVs involved. Databases has 'Trucate table' for a reason. The post head
3. 33.▲
   by venkat971 3y ago

   We use Seam, it's the best thing that is happening for the messy IoT integrations.