ServiceNow – Indexes – Quick Guide I скачать в хорошем качестве

ServiceNow – Indexes – Quick Guide I

If you're a ServiceNow Administrator or Developer, you need to ensure queries to your tables are performant, and for that you need table indexes. In Part 1 of this two-part series, this video provides a overview of what indexes are and a simple demonstration of how they can dramatically improve query times. Links to further learning: • Getting Started with Indexes (MariaDB Documentation) https://mariadb.com/kb/en/getting-sta... • How MySQL Uses Indexes (MySQL Documentation) https://dev.mysql.com/doc/refman/8.0/... • Database indexing for dumb developers (YouTube)    • Database Indexing for Dumb Developers   (Apologies for the demeaning title, but the video provides a very good introduction to indexing.) • What index should it be? - OR - Slow Queries explained (ServiceNow Community) https://www.servicenow.com/community/... • Improve performance: database indexes and slow queries (ServiceNow Community) https://www.servicenow.com/community/... Timecodes 0:00 Intro & reasons you need indexes 1:15 How an index works 2:17 Demo – The scenario 2:58 Query testing I – without an index 5:00 Timing queries with GlideStopWatch() 7:21 Creating an index 9:00 Query testing II – with an index 10:27 Conclusion