DZone
Performance Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Performance Zone > The Best of the Week (May 9): SQL Zone

The Best of the Week (May 9): SQL Zone

Alec Noller user avatar by
Alec Noller
·
May. 18, 14 · Performance Zone · Interview
Like (0)
Save
Tweet
4.28K Views

Join the DZone community and get the full member experience.

Join For Free

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (May 9 to May 15). Here they are, in order of popularity:

1. Myth: Select * Is Bad

This is one of the most persistent myths the author has seen in the field. It’s been there for decades. If a myth is alive that long, there must be some truth behind it. So, what could be bad about select *? Let’s have a closer look.

2. Results of the SQL Performance Quiz: 60% Fail

In 2011, the author launched “The 3-Minute Test: What do you know about SQL performance.” It consists of five questions that follow a simple pattern: each shows a query/index pair and asks if it demonstrates proper indexing or not. This article analyzes the 28,000 responses to spot patterns and make observations.

3. The Index You’ve Added is Useless. Why?

In this article, the author explores the fact that Oracle doesn't put NULL values in "ordinary" indexes, the problems this can cause, and how to get around them.

4. How to Import CSV Data into PostgreSQL

Many database servers support CSV data transfers, and this post will show one way you can import CSV files to PostgreSQL.

5. GTIDs in MySQL 5.6: New Replication Protocol, New Ways to Break Replication

Reconnecting a slave to a new master in MySQL 5.6 has always been a challenge, but it is so trivial when GTIDs are enabled. However, using GTIDs is not only about replacing good old binlog file/position with unique identifiers; it is also using a new replication protocol. And if you are not aware of it, it can bite.

MySQL

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • A Guide to Understanding Vue Lifecycle Hooks
  • Ultra-Fast Microservices in Java: When Microstream Meets Open Liberty
  • How Does the Database Understand and Execute Your Query?
  • How Data and Analysis Can Power Agile Teams

Comments

Performance Partner Resources

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo