180 place 0
![[Translation] Whose feature is better, or how to compare the efficiency of SQL query plans](https://times42.com/media/4/3/3/10692433_640x200.jpg "[Translation] Whose feature is better, or how to compare the efficiency of SQL query plans")
How to compare the efficiency of SQL query plans? “Measure the execution time, of course!” — an experienced reader would say. And they would be absolutely right: from a practical perspective, the more efficient DBMS is the one that delivers higher TPS. However, sometimes we need to design a system that doesn't exist yet or predict behavior under loads that haven't occurred yet. In such cases, we need a characteristic that allows us to perform a qualitative analysis of a plan or compare two plans. This post.
A newsletter a day!
You may get 10 most important news around midday in daily newsletter. Press the button and we will send you the most important news only, no spam attached.
LIKE us on Facebook so you won't miss the most important news of the day!
Habr
Authorities say the shooter left a note claiming he had CTE, a brain disease linked to repeated head trauma. Read more ›
1,908 fresh
Nicknamed "Golf Force One," the golf cart is one of many vehicles the Secret Service uses to protect the commander in chief. Read more ›
750
GOP senators dismissed the idea of sending tariff revenue checks to Americans, with one saying it's "the dumbest idea I've ever heard." Read more ›
595
Google is working on a fix for an issue in Android 16 that causes Google Play System updates to fail during installation. Read more ›
473 fresh
This story appeared in The Logoff, a daily newsletter that helps you stay informed about the Trump administration without letting political news take over your life. Subscribe here. Welcome to The Logoff: President Donald Trump’s Environmental Protection Agency said today that it plans to reverse its own legal justification for regulating emissions, potentially a major blow to […] Read more ›
381 fresh
We're just six weeks away from the launch of new iPhone models, and rumors are ramping up as September creeps closer. We've heard plenty of details about the prospective colors for the iPhone 17 lineup, but leaker Sonny Dickson today shared iPhone 17 dummy models that supposedly feature the shades that Apple has picked. Dickson's images feature the iPhone 17 Pro models in black, white, dark blue, and orange. The... Read more ›
347 fresh
Corporate America is racing to boost security and reassure employees after a shooting left a top Blackstone exec dead, along with four others. Read more ›
285 fresh
A laptop will cost you more today, but maybe one day you'll get a check in the mail. Read more ›
273
Time is running out for countries to reach an agreement to avoid Donald Trump's delayed tariffs. Read more ›
252
Apple today filed a response to the antitrust lawsuit it is facing from the United States Department of Justice, sharing rebuttals to the DoJ's claims and pointing out perceived flaws in the accusations outlined in the complaint. According to Apple, the DoJ's lawsuit has the potential to "set a dangerous precedent" that would allow the government to dictate the design and function of technology, plus it threatens "the very principles... Read more ›
186 fresh
Apple today released iOS 18.6 and iPadOS 18.6, the sixth updates to the iOS 18 and iPadOS 18 operating systems. iOS 18.6 and iPadOS 18.6 come more than two months after the release of iOS 18.5 and iPadOS 18.5. The new software can be downloaded on eligible iPhones and iPads over-the-air by going to Settings > General > Software Update. iOS 18.6 addresses a Photos-related bug that could prevent users... Read more ›
177
Wesley LePatner was Blackstone's head of real estate and CEO of an evergreen real estate fund. She was a BI rising star. Read more ›
171
YouTube videos with strong profanity in the first seven seconds (words like “fuck”) are now eligible for full monetization, according to a video from Conor, YouTube’s head of monetization policy experience. Previously, these kinds of videos were only eligible for “limited ad revenue.” Changes to YouTube’s inappropriate language policies have long been a sore spot […] Read more ›
171 fresh
“When you have an extended period of prosperity with no existential war, there’s no cleansing function..." Read more ›
164
YouTube is starting its age checks in the US, so maybe stop watching so many Roblox videos. Read more ›
146
Apple today provided beta testers with updated beta firmware for the AirPods Pro 2 and AirPods 4, allowing them to test the new AirPods features in iOS 26, iPadOS 26, and macOS Tahoe. The firmware is only available to developers and public beta testers at the current time, and a device running iOS 26, iPadOS 26, or macOS 26 is required to install the update. The firmware has a build... Read more ›
131
A few months ago, we reported that select scenes in the post-apocalyptic film "28 Years Later" were shot with a rig of up to 20 iPhones. Now, the film's director Danny Boyle has discussed this feat in a YouTube video uploaded to the Apple TV channel today. "Director Danny Boyle pushed the power of iPhone to new cinematic heights in select scenes of 28 Years Later," says Apple. "In fact,... Read more ›
108
That’s bad news for human health. Read more ›
108 fresh
Ever wondered who really owns OnePlus and where those sleek phones come from? Here are the answers to your questions. Read more ›
106 fresh
Habr
A reflection on how one simple change of question transforms the approach to understanding consciousness. And the Vortex Protocol: A Prompt for Testing the Hypotheses. Where All Discussions on Consciousness Break DownI've mentioned before that there's one question capable of instantly destroying the constructiveness of any discussion about the future of AI, neuroscience, or philosophy, no matter how interesting. It's the unfailing move of someone who disagrees with an opponent's... Read more ›
6
![[Translation] ML Q & AI. Глава 4. Гипотеза о лотерейном билете](https://times42.com/media/8/4/4/10886844_640x200.jpg "[Translation] ML Q & AI. Глава 4. Гипотеза о лотерейном билете")
Предыдущая главаО чем говорит гипотеза о лотерейном билете, и чем она полезна на практике, если оказывается верной?Гипотеза о лотерейном билете — это идея, которая появилась в 2018 году в контексте обучения нейронных сетей. Она утверждает, что в случайно инициализированной нейронной сети существует подсеть (или "выигрышный билет"), которая, если ее обучить независимо, сможет достичь такой же точности на тестовом датасете, как и полная сеть после такого же количества шагов обучения. Авторы... Read more ›
0
For a human, AI is just a part of being. For a model, a human is all of being. And the Vortex Protocol: A Prompt for Testing the Hypotheses. The longest and most fruitless discussions tend to be with materialists, especially those close to the position Marx laid out as "Being determines consciousness." It's amusing that Marx was talking about the economic base, but the clarity and precision of this... Read more ›
0
The students of the Intelligent Systems Department successfully defended their bachelor’s and master’s theses. This year, 14 Bachelor’s and 8 Master’s students earned their degrees in Physics, Mathematics, and Computer Sciences. We are proud to say that our Department is unique in publishing the complete set of defense materials during the last ten years. These materials include the text of the dissertation work, the published papers, the code of the... Read more ›
0
![[Translation] Getting to know PPEM 2](https://times42.com/media/2/0/9/10903209_640x200.jpg "[Translation] Getting to know PPEM 2")
Postgres Pro recently announced the release of Enterprise Manager 2, commonly known as PPEM.In short, PPEM is an administration tool designed for managing and monitoring Postgres databases. Its primary goal is to assist DBAs in their daily tasks and automate routine operations. In this article, I'll take a closer look at what PPEM has to offer. My name is Alexey, and I'm part of the PPEM development team. Read more Read more ›
0
Обнаруженная в середине июля атака ToolShell стала одним из самых серьезных событий в сфере корпоративной IT-безопасности этого лета. Не до конца пропатченные уязвимости в Microsoft SharePoint привели к взлому большого количества standalone-инсталляций, до того как производитель ПО выпустил патч. За восемь дней, прошедших с момента выпуска патчей, исследователи Microsoft зафиксировали множество атак, в ряде случаев приводящих к шифрованию данных с последующим требованием выкупа. Read more Read more ›
0
Most popular sources
Business Insider
|
33% 10 |
MacRumors
|
10% 5 |
Gizmodo
|
10% 2 |
Android Authority
|
6% 1 |
Wired
|
5% 3 |
| View sources » | |
LIKE us on Facebook so you won't miss the most important news of the day!
30.07.2025 01:30
Last update: 01:20 EDT.
News rating updated: 08:21.
What is Times42?
Times42 brings you the most popular news from tech news portals in real-time chart.
Read about us in FAQ section.
