Chris Saxon's Recent LinkedIn Posts

Change an Oracle table to be insert-only with ALTER TABLE ... BECOME IMMUTABLE NO DROP ... NO DELETE ... This then blocks UPDATEs to the rows You can only remove - rows older than the NO DELETE setting - the table if there's no new rows since the NO DROP setting

ICYMI: Oracle AI Database 26ai Free 23.26.3 is now available Download it at https://lnkd.in/eFYWA4E3 There are lots of security fixes in this RU - I strongly recommend you get this whatever you use Free for. There are also a few #SQL features - DATEADD is great for simplifying date logic

Omit rows from the window function results with OVER ( ORDER BY ... EXCLUDE ... ) CURRENT ROW => this row GROUP => current row + others with same value TIES => others with the same value as the current row NONE => no rows (default) This enables you to skip duplicate values

Think you know about #SQL performance? Take this 3-minute indexing quiz by Markus Winand A simple test that 60% fail! https://lnkd.in/ejRx5pbn Did you pass? Let us know how you did!

Want to see what happens when you run a query in Oracle AI Database? Kamil Stawiarski has built OraCity - a visualisation of the process as a 3D city Follow the steps the query goes through from parsing, to planning, to running through its plan

Want to ensure assertions in Oracle AI Database run as fast as possible? Here are three tips to get you started: 𝐂𝐫𝐞𝐚𝐭𝐞 𝐚𝐬𝐬𝐞𝐫𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐭𝐡𝐞 𝐍𝐎𝐕𝐀𝐋𝐈𝐃𝐀𝐓𝐄 𝐬𝐭𝐚𝐭𝐞 This skips validation, so is instant. But there may be rows that violate the constraint 𝐅𝐨𝐫𝐜𝐞 𝐩𝐚𝐫𝐚𝐥𝐥𝐞𝐥 𝐪𝐮𝐞…