Which Order Should Columns Go in an Index?: Finding All the Red Sweets Part 4
When you create an index on multiple columns there's an important question you need to answer:
In which order should you list the columns?
This video looks at some of the factors you should consider to help answer this question.
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Видео Which Order Should Columns Go in an Index?: Finding All the Red Sweets Part 4 канала The Magic of SQL
In which order should you list the columns?
This video looks at some of the factors you should consider to help answer this question.
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Видео Which Order Should Columns Go in an Index?: Finding All the Red Sweets Part 4 канала The Magic of SQL
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
The Vanishing One Second WaitsThe Magic of SQL: The Cups and Balls TrickQuery Tuning 101 What to Look for in Autotrace OutputThe Magic of SQL: The Magical Changing RowCross joins - SQL in 60 seconds #shortsWindow functions ORDER BY PRECEDING & FOLLOWING - SQL in 60 seconds #shortsSchema Wars Episode 3: The SQL RedemptionAnalytic Functions: Databases for Developers #13What Are Foriegn Keys? A Video QuizQuery Tuning 101: Access vs. Filter Predicates In Execution PlansWhat Are Not Null Constraints? A Video QuizWhat are Primary Keys - A Video QuizSchema Wars Episode 2: Master DBA Strikes BackThe Magic of SQL: Magical Changing Row - Behind the CurtainWindow functions ORDER BY - SQL in 60 seconds #shortsSolve It with SQL: Removing Points from a Linked ListThe Magic of SQL: The 4 JacksON vs USING for joins - SQL in 60 seconds #shortsFree guess the SQL statement quizzesHow to Create Database Indexes: Databases for Developers: Performance #4The Magic of SQL: Cups and Balls Behind the Curtain