T i m i n g   i s   o n . 
 
 E x p a n d e d   d i s p l a y   i s   u s e d   a u t o m a t i c a l l y . 
 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 J e l l y f i n   S l o w   Q u e r y   A n a l y s i s 
 
 G e n e r a t e d :   2 0 2 6 - 0 3 - 0 5 
 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 
 
 1 .   C H E C K I N G   p g _ s t a t _ s t a t e m e n t s   E X T E N S I O N 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
                               s t a t u s                               
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
       p g _ s t a t _ s t a t e m e n t s   i s   i n s t a l l e d 
 
 ( 1   r o w ) 
 
 
 
 T i m e :   6 . 3 8 8   m s 
 
 
 
 2 .   T O P   2 0   S L O W E S T   Q U E R I E S   ( b y   m a x   e x e c u t i o n   t i m e ) 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 T h e s e   a r e   t h e   q u e r i e s   t h a t   h a v e   t a k e n   t h e   l o n g e s t   t i m e   t o   e x e c u t e 
 
 
 
                                                                                         q u e r y _ p r e v i e w                                                                                           |   c a l l s     |     a v g _ m s     |     m a x _ m s       |     m i n _ m s     |   s t d d e v _ m s   |     t o t a l _ m s     |   p c t _ t o t a l   |   r o w s _ r e t u r n e d   
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - - - - - 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |           4 8   |     4 4 4 2 . 7 5   |   1 1 0 0 4 8 . 0 0   |           0 . 0 6   |     1 6 4 0 2 . 4 6   |     2 1 3 2 5 1 . 8 9   |             0 . 9 5   |                 6 8 6 2 4 5 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |           7 6   |     3 2 2 9 . 7 2   |     3 6 3 3 7 . 2 1   |           4 . 9 7   |       9 0 9 2 . 3 9   |     2 4 5 4 5 8 . 4 7   |             1 . 1 0   |                 1 0 2 2 7 0 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |           5 2   |     7 8 6 6 . 0 5   |     2 6 0 9 6 . 6 5   |     5 0 0 6 . 5 1   |       3 8 0 5 . 7 0   |     4 0 9 0 3 4 . 5 6   |             1 . 8 3   |                   3 6 5 7 4 
 
   U P D A T E   l i b r a r y . " U s e r D a t a "   S E T   " A u d i o S t r e a m I n d e x "   =   $ 1 ,   " I s F a v o r i t e "   =   $ 2 ,   " L a s t P l a y e d D a t e "   =   $ 3 ,   " L i   |     1 4 3 1 6   |       1 0 6 . 9 1   |     2 3 8 5 1 . 5 3   |           0 . 0 3   |         9 8 8 . 3 0   |   1 5 3 0 5 0 1 . 4 2   |             6 . 8 3   |                   1 4 3 1 6 
 
   v a c u u m   a n a l y z e                                                                                                                                                                               |             1   |   2 1 7 7 4 . 0 1   |     2 1 7 7 4 . 0 1   |   2 1 7 7 4 . 0 1   |             0 . 0 0   |       2 1 7 7 4 . 0 1   |             0 . 1 0   |                           0 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |           5 3   |     5 9 8 6 . 9 6   |     1 2 8 9 0 . 7 2   |     5 0 7 2 . 2 2   |       1 2 1 6 . 4 6   |     3 1 7 3 0 8 . 8 9   |             1 . 4 2   |                   1 6 6 1 7 
 
   S E L E C T   p . " I d " ,   p . " N a m e " ,   p . " P e r s o n T y p e "                                                                                                                           + |   2 1 1 8 2 5   |           1 . 1 6   |     1 2 0 9 4 . 9 5   |           0 . 0 2   |           4 3 . 9 5   |     2 4 6 7 5 6 . 2 4   |             1 . 1 0   |               1 7 7 3 8 1 4 
 
   F R O M   l i b r a r y . " P e o p l e s "   A S   p                                                                                                                                                   + |                 |                     |                       |                     |                       |                         |                       |   
 
   W H E R E   E X I S T S   (                                                                                                                                                                             + |                 |                     |                       |                     |                       |                         |                       |   
 
           S E L E C T   $ 3                                                                                                                                                                               + |                 |                     |                       |                     |                       |                         |                       |   
 
                                                                                                                                                                                                             |                 |                     |                       |                     |                       |                         |                       |   
 
   U P D A T E   l i b r a r y . " B a s e I t e m s "   S E T   " A l b u m "   =   $ 1 ,   " A l b u m A r t i s t s "   =   $ 2 ,   " A r t i s t s "   =   $ 3 ,   " A u d i o "   =   $ 4 ,   " C h a   |   4 0 6 5 1 3   |           1 . 0 2   |       9 4 2 6 . 4 8   |           0 . 0 5   |           2 7 . 9 6   |     4 1 2 6 6 9 . 1 9   |             1 . 8 4   |                 4 0 6 5 1 3 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |           1 0   |     2 2 0 6 . 5 2   |       9 4 2 1 . 8 6   |       2 5 1 . 4 7   |       2 7 3 3 . 7 3   |       2 2 0 6 5 . 2 2   |             0 . 1 0   |                         4 2 
 
   V A C U U M   A N A L Y Z E   " l i b r a r y " . " B a s e I t e m s "                                                                                                                                   |             4   |     5 2 4 4 . 5 0   |       9 2 7 0 . 5 6   |     3 1 4 8 . 6 0   |       2 3 6 9 . 9 5   |       2 0 9 7 8 . 0 0   |             0 . 0 9   |                           0 
 
   C O P Y   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " T y p e " ,   " D a t a " ,   " P a t h " ,   " S t a r t D a t e " ,   " E n d D a t e " ,   " C h a n n e l I d " ,   " I s M o v i   |             9   |     4 0 2 0 . 6 3   |       9 0 6 3 . 5 0   |     2 5 3 8 . 7 4   |       1 8 6 6 . 1 4   |       3 6 1 8 5 . 6 4   |             0 . 1 6   |               1 1 0 8 5 4 2 
 
   I N S E R T   I N T O   l i b r a r y . " M e d i a S t r e a m I n f o s "   ( " I t e m I d " ,   " S t r e a m I n d e x " ,   " A s p e c t R a t i o " ,   " A v e r a g e F r a m e R a t e " ,     |   1 0 1 3 0 6   |           0 . 9 3   |       8 7 7 3 . 5 9   |           0 . 0 7   |           3 1 . 8 7   |       9 4 1 0 3 . 9 5   |             0 . 4 2   |                 1 0 1 3 0 6 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a   |     7 9 5 7 1   |           9 . 2 1   |       7 6 3 5 . 5 0   |           0 . 0 4   |           4 8 . 7 8   |     7 3 2 5 6 7 . 2 1   |             3 . 2 7   |             1 0 1 9 0 4 6 9 
 
   S E L E C T   b 5 . " I d " ,   b 5 . " A l b u m " ,   b 5 . " A l b u m A r t i s t s " ,   b 5 . " A r t i s t s " ,   b 5 . " A u d i o " ,   b 5 . " C h a n n e l I d " ,   b 5 . " C l e a n N a   |           3 3   |       7 4 0 . 0 5   |       7 2 1 5 . 2 9   |           0 . 1 8   |       1 7 8 9 . 1 1   |       2 4 4 2 1 . 5 2   |             0 . 1 1   |                       2 9 1 
 
   A N A L Y Z E   l i b r a r y . " B a s e I t e m s "                                                                                                                                                     |             2   |     3 5 9 8 . 8 5   |       7 1 9 1 . 2 3   |           6 . 4 6   |       3 5 9 2 . 3 9   |         7 1 9 7 . 6 9   |             0 . 0 3   |                           0 
 
   A N A L Y Z E   V E R B O S E                                                                                                                                                                             |             1   |     7 0 1 6 . 0 6   |       7 0 1 6 . 0 6   |     7 0 1 6 . 0 6   |             0 . 0 0   |         7 0 1 6 . 0 6   |             0 . 0 3   |                           0 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |           5 3   |       3 2 3 . 4 5   |       6 8 5 9 . 7 1   |           4 . 8 7   |       1 1 4 1 . 5 8   |       1 7 1 4 2 . 8 9   |             0 . 0 8   |                   2 1 8 1 3 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |             5   |     5 7 1 3 . 8 8   |       6 5 5 0 . 2 6   |     5 2 3 6 . 6 7   |         4 4 5 . 8 0   |       2 8 5 6 9 . 3 9   |             0 . 1 3   |                     7 0 6 9 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                 + |           4 5   |     1 0 2 6 . 6 4   |       6 5 4 1 . 0 0   |       1 9 4 . 0 7   |       1 1 3 9 . 2 7   |       4 6 1 9 8 . 7 5   |             0 . 2 1   |                         4 5 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |                 |                     |                       |                     |                       |                         |                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |                 |                     |                       |                     |                       |                         |                       |   
 
           S E L E C T   (                                                                                                                                                                                 + |                 |                     |                       |                     |                       |                         |                       |   
 
                   S E L E C T   b 1 .                                                                                                                                                                       |                 |                     |                       |                     |                       |                         |                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |         1 0 2   |       3 6 4 . 8 1   |       6 2 5 3 . 6 6   |           0 . 0 5   |         9 9 8 . 3 6   |       3 7 2 1 0 . 1 7   |             0 . 1 7   |                       1 1 1 
 
 ( 2 0   r o w s ) 
 
 
 
 T i m e :   5 1 . 2 3 8   m s 
 
 
 
 3 .   T O P   2 0   S L O W E S T   Q U E R I E S   ( b y   a v e r a g e   e x e c u t i o n   t i m e ) 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 T h e s e   q u e r i e s   c o n s i s t e n t l y   t a k e   a   l o n g   t i m e 
 
 
 
                                                                                         q u e r y _ p r e v i e w                                                                                           |   c a l l s   |   a v g _ m s     |     m a x _ m s       |   t o t a l _ m s     |   p c t _ t o t a l   |   r o w s _ r e t u r n e d   |   a v g _ r o w s _ p e r _ c a l l   
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - + - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |         5 2   |   7 8 6 6 . 0 5   |     2 6 0 9 6 . 6 5   |   4 0 9 0 3 4 . 5 6   |             1 . 8 3   |                   3 6 5 7 4   |                         7 0 3 . 3 5 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |         5 3   |   5 9 8 6 . 9 6   |     1 2 8 9 0 . 7 2   |   3 1 7 3 0 8 . 8 9   |             1 . 4 2   |                   1 6 6 1 7   |                         3 1 3 . 5 3 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |           5   |   5 7 1 3 . 8 8   |       6 5 5 0 . 2 6   |     2 8 5 6 9 . 3 9   |             0 . 1 3   |                     7 0 6 9   |                       1 4 1 3 . 8 0 
 
   V A C U U M   A N A L Y Z E   " l i b r a r y " . " B a s e I t e m s "                                                                                                                                   |           4   |   5 2 4 4 . 5 0   |       9 2 7 0 . 5 6   |     2 0 9 7 8 . 0 0   |             0 . 0 9   |                           0   |                             0 . 0 0 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |         4 8   |   4 4 4 2 . 7 5   |   1 1 0 0 4 8 . 0 0   |   2 1 3 2 5 1 . 8 9   |             0 . 9 5   |                 6 8 6 2 4 5   |                     1 4 2 9 6 . 7 7 
 
   C O P Y   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " T y p e " ,   " D a t a " ,   " P a t h " ,   " S t a r t D a t e " ,   " E n d D a t e " ,   " C h a n n e l I d " ,   " I s M o v i   |           9   |   4 0 2 0 . 6 3   |       9 0 6 3 . 5 0   |     3 6 1 8 5 . 6 4   |             0 . 1 6   |               1 1 0 8 5 4 2   |                   1 2 3 1 7 1 . 3 3 
 
   A N A L Y Z E   l i b r a r y . " B a s e I t e m s "                                                                                                                                                     |           2   |   3 5 9 8 . 8 5   |       7 1 9 1 . 2 3   |       7 1 9 7 . 6 9   |             0 . 0 3   |                           0   |                             0 . 0 0 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |         7 6   |   3 2 2 9 . 7 2   |     3 6 3 3 7 . 2 1   |   2 4 5 4 5 8 . 4 7   |             1 . 1 0   |                 1 0 2 2 7 0   |                       1 3 4 5 . 6 6 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |         3 3   |   2 6 4 3 . 2 2   |       3 8 3 9 . 3 5   |     8 7 2 2 6 . 4 0   |             0 . 3 9   |                         9 3   |                             2 . 8 2 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |         1 0   |   2 2 0 6 . 5 2   |       9 4 2 1 . 8 6   |     2 2 0 6 5 . 2 2   |             0 . 1 0   |                         4 2   |                             4 . 2 0 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                 + |         3 3   |   1 7 4 2 . 2 1   |       2 5 6 6 . 9 8   |     5 7 4 9 2 . 8 7   |             0 . 2 6   |                         3 3   |                             1 . 0 0 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |               |                   |                       |                       |                       |                               |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |               |                   |                       |                       |                       |                               |   
 
           S E L E C T   (                                                                                                                                                                                 + |               |                   |                       |                       |                       |                               |   
 
                   S E L E C T   b 1 .                                                                                                                                                                       |               |                   |                       |                       |                       |                               |   
 
   S E L E C T   b . " I d "                                                                                                                                                                               + |         1 0   |   1 4 9 8 . 4 2   |       4 2 5 4 . 2 9   |     1 4 9 8 4 . 1 8   |             0 . 0 7   |                           0   |                             0 . 0 0 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |               |                   |                       |                       |                       |                               |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |               |                   |                       |                       |                       |                               |   
 
           S E L E C T   (                                                                                                                                                                                 + |               |                   |                       |                       |                       |                               |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                             + |               |                   |                       |                       |                       |                               |   
 
                                                                                                                                                                                                             |               |                   |                       |                       |                       |                               |   
 
   C O P Y   l i b r a r y . " P e o p l e B a s e I t e m M a p "   ( " R o l e " ,   " I t e m I d " ,   " P e o p l e I d " ,   " S o r t O r d e r " ,   " L i s t O r d e r " )   T O   s t d o u t     |           9   |   1 3 5 1 . 5 5   |       2 6 4 7 . 1 2   |     1 2 1 6 3 . 9 1   |             0 . 0 5   |               2 7 0 9 4 5 2   |                   3 0 1 0 5 0 . 2 2 
 
   V A C U U M   A N A L Y Z E   " l i b r a r y " . " P e o p l e B a s e I t e m M a p "                                                                                                                   |           4   |   1 3 4 6 . 2 4   |       2 4 4 0 . 1 3   |       5 3 8 4 . 9 6   |             0 . 0 2   |                           0   |                             0 . 0 0 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |         4 5   |   1 2 6 2 . 5 9   |       3 9 0 1 . 6 4   |     5 6 8 1 6 . 6 0   |             0 . 2 5   |                       1 5 6   |                             3 . 4 7 
 
   C O P Y   l i b r a r y . " B a s e I t e m I m a g e I n f o s "   ( " I d " ,   " P a t h " ,   " D a t e M o d i f i e d " ,   " I m a g e T y p e " ,   " W i d t h " ,   " H e i g h t " ,   " B l   |         1 0   |   1 0 9 6 . 7 8   |       2 2 2 9 . 7 7   |     1 0 9 6 7 . 8 0   |             0 . 0 5   |                 7 8 6 2 3 2   |                     7 8 6 2 3 . 2 0 
 
   V A C U U M   A N A L Y Z E   " l i b r a r y " . " B a s e I t e m P r o v i d e r s "                                                                                                                   |           4   |   1 0 7 1 . 4 7   |       1 8 9 1 . 5 5   |       4 2 8 5 . 8 9   |             0 . 0 2   |                           0   |                             0 . 0 0 
 
   V A C U U M   A N A L Y Z E   " l i b r a r y " . " B a s e I t e m I m a g e I n f o s "                                                                                                                 |           4   |   1 0 3 4 . 9 2   |       1 3 9 4 . 1 7   |       4 1 3 9 . 6 8   |             0 . 0 2   |                           0   |                             0 . 0 0 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                 + |         4 5   |   1 0 2 6 . 6 4   |       6 5 4 1 . 0 0   |     4 6 1 9 8 . 7 5   |             0 . 2 1   |                         4 5   |                             1 . 0 0 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |               |                   |                       |                       |                       |                               |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |               |                   |                       |                       |                       |                               |   
 
           S E L E C T   (                                                                                                                                                                                 + |               |                   |                       |                       |                       |                               |   
 
                   S E L E C T   b 1 .                                                                                                                                                                       |               |                   |                       |                       |                       |                               |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |         2 0   |   1 0 0 6 . 4 5   |       4 5 9 5 . 5 4   |     2 0 1 2 9 . 0 3   |             0 . 0 9   |                         3 6   |                             1 . 8 0 
 
 ( 2 0   r o w s ) 
 
 
 
 T i m e :   4 0 . 9 4 1   m s 
 
 
 
 4 .   Q U E R I E S   W I T H   H I G H E S T   T O T A L   T I M E 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 T h e s e   q u e r i e s   c o n s u m e   t h e   m o s t   t o t a l   d a t a b a s e   t i m e 
 
 
 
                                                                                         q u e r y _ p r e v i e w                                                                                           |     c a l l s     |   a v g _ m s     |     m a x _ m s       |     t o t a l _ m s     |   p c t _ t o t a l   |   t o t a l _ m i n u t e s   
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - - - - - - - 
 
   S E L E C T   p . " I d " ,   p . " N a m e " ,   p . " P e r s o n T y p e "                                                                                                                           + |     1 4 4 0 5 5   |       5 4 . 7 9   |         4 9 2 . 4 3   |   7 8 9 3 0 9 7 . 6 5   |           3 5 . 2 3   |                 1 3 1 . 5 5 
 
   F R O M   l i b r a r y . " P e o p l e s "   A S   p                                                                                                                                                   + |                   |                   |                       |                         |                       |   
 
   W H E R E   p . " N a m e "   | |   $ 2   | |   C O A L E S C E                                                                                                                                           |                   |                   |                       |                         |                       |   
 
   S E L E C T   i . " I t e m V a l u e I d " ,   i . " C l e a n V a l u e " ,   i . " T y p e " ,   i . " V a l u e "                                                                                   + |     5 0 4 9 4 7   |         4 . 6 0   |           7 5 . 7 3   |   2 3 2 1 4 4 4 . 6 5   |           1 0 . 3 6   |                   3 8 . 6 9 
 
   F R O M   l i b r a r y . " I t e m V a l u e s "   A S   i                                                                                                                                             + |                   |                   |                       |                         |                       |   
 
   W H E R E   i . "                                                                                                                                                                                         |                   |                   |                       |                         |                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a   |       1 3 0 9 1   |     1 2 2 . 8 8   |       1 8 0 2 . 9 2   |   1 6 0 8 6 0 2 . 6 5   |             7 . 1 8   |                   2 6 . 8 1 
 
   U P D A T E   l i b r a r y . " U s e r D a t a "   S E T   " A u d i o S t r e a m I n d e x "   =   $ 1 ,   " I s F a v o r i t e "   =   $ 2 ,   " L a s t P l a y e d D a t e "   =   $ 3 ,   " L i   |       1 4 3 1 6   |     1 0 6 . 9 1   |     2 3 8 5 1 . 5 3   |   1 5 3 0 5 0 1 . 4 2   |             6 . 8 3   |                   2 5 . 5 1 
 
   S E L E C T   b 4 . " I d " ,   b 4 . " A l b u m " ,   b 4 . " A l b u m A r t i s t s " ,   b 4 . " A r t i s t s " ,   b 4 . " A u d i o " ,   b 4 . " C h a n n e l I d " ,   b 4 . " C l e a n N a   |   2 8 8 9 7 4 9   |         0 . 3 1   |         3 3 5 . 5 9   |     9 0 1 5 1 1 . 9 8   |             4 . 0 2   |                   1 5 . 0 3 
 
   I N S E R T   I N T O   l i b r a r y . " I t e m V a l u e s M a p "   ( " I t e m I d " ,   " I t e m V a l u e I d " )                                                                               + |   1 2 3 5 7 8 9   |         0 . 6 4   |       5 3 3 3 . 1 2   |     7 9 0 2 1 1 . 4 2   |             3 . 5 3   |                   1 3 . 1 7 
 
   V A L U E S   ( $ 1 ,   $ 2 )                                                                                                                                                                             |                   |                   |                       |                         |                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a   |       7 9 5 7 1   |         9 . 2 1   |       7 6 3 5 . 5 0   |     7 3 2 5 6 7 . 2 1   |             3 . 2 7   |                   1 2 . 2 1 
 
   I N S E R T   I N T O   l i b r a r y . " B a s e I t e m P r o v i d e r s "   ( " I t e m I d " ,   " P r o v i d e r I d " ,   " P r o v i d e r V a l u e " )                                       + |     9 9 9 5 3 0   |         0 . 6 3   |         2 3 4 . 7 6   |     6 3 0 8 7 8 . 7 9   |             2 . 8 2   |                   1 0 . 5 1 
 
   V A L U E S   ( $ 1 ,   $ 2 ,   $ 3                                                                                                                                                                       |                   |                   |                       |                         |                       |   
 
   I N S E R T   I N T O   l i b r a r y . " B a s e I t e m I m a g e I n f o s "   ( " I d " ,   " B l u r h a s h " ,   " D a t e M o d i f i e d " ,   " H e i g h t " ,   " I m a g e T y p e " ,   "   |     8 6 4 3 2 3   |         0 . 7 0   |       2 0 3 4 . 4 2   |     6 0 2 3 7 6 . 4 4   |             2 . 6 9   |                   1 0 . 0 4 
 
   I N S E R T   I N T O   l i b r a r y . " P e o p l e B a s e I t e m M a p "   ( " I t e m I d " ,   " P e o p l e I d " ,   " R o l e " ,   " L i s t O r d e r " ,   " S o r t O r d e r " )         + |     6 1 0 7 8 9   |         0 . 7 9   |         2 9 1 . 0 9   |     4 8 2 6 8 2 . 2 5   |             2 . 1 5   |                     8 . 0 4 
 
   V A L                                                                                                                                                                                                     |                   |                   |                       |                         |                       |   
 
   U P D A T E   l i b r a r y . " B a s e I t e m s "   S E T   " A l b u m "   =   $ 1 ,   " A l b u m A r t i s t s "   =   $ 2 ,   " A r t i s t s "   =   $ 3 ,   " A u d i o "   =   $ 4 ,   " C h a   |     4 0 6 5 1 3   |         1 . 0 2   |       9 4 2 6 . 4 8   |     4 1 2 6 6 9 . 1 9   |             1 . 8 4   |                     6 . 8 8 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |             5 2   |   7 8 6 6 . 0 5   |     2 6 0 9 6 . 6 5   |     4 0 9 0 3 4 . 5 6   |             1 . 8 3   |                     6 . 8 2 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a   |         7 1 7 8   |       4 7 . 9 6   |       1 8 7 9 . 0 4   |     3 4 4 2 6 5 . 6 9   |             1 . 5 4   |                     5 . 7 4 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |             5 3   |   5 9 8 6 . 9 6   |     1 2 8 9 0 . 7 2   |     3 1 7 3 0 8 . 8 9   |             1 . 4 2   |                     5 . 2 9 
 
   S E L E C T   p . " I d " ,   p . " N a m e " ,   p . " P e r s o n T y p e "                                                                                                                           + |     2 1 1 8 2 5   |         1 . 1 6   |     1 2 0 9 4 . 9 5   |     2 4 6 7 5 6 . 2 4   |             1 . 1 0   |                     4 . 1 1 
 
   F R O M   l i b r a r y . " P e o p l e s "   A S   p                                                                                                                                                   + |                   |                   |                       |                         |                       |   
 
   W H E R E   E X I S T S   (                                                                                                                                                                             + |                   |                   |                       |                         |                       |   
 
           S E L E C T   $ 3                                                                                                                                                                               + |                   |                   |                       |                         |                       |   
 
                                                                                                                                                                                                             |                   |                   |                       |                         |                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a   |             7 6   |   3 2 2 9 . 7 2   |     3 6 3 3 7 . 2 1   |     2 4 5 4 5 8 . 4 7   |             1 . 1 0   |                     4 . 0 9 
 
   S E L E C T   b 2 . " I d " ,   b 2 . " A l b u m " ,   b 2 . " A l b u m A r t i s t s " ,   b 2 . " A r t i s t s " ,   b 2 . " A u d i o " ,   b 2 . " C h a n n e l I d " ,   b 2 . " C l e a n N a   |       3 7 2 8 3   |         6 . 5 3   |       3 8 4 3 . 1 7   |     2 4 3 3 3 5 . 2 1   |             1 . 0 9   |                     4 . 0 6 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |             4 8   |   4 4 4 2 . 7 5   |   1 1 0 0 4 8 . 0 0   |     2 1 3 2 5 1 . 8 9   |             0 . 9 5   |                     3 . 5 5 
 
   I N S E R T   I N T O   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " A l b u m " ,   " A l b u m A r t i s t s " ,   " A r t i s t s " ,   " A u d i o " ,   " C h a n n e l I d " ,   " C l   |     1 3 2 7 9 2   |         1 . 4 4   |       3 1 7 1 . 8 3   |     1 9 0 8 3 9 . 2 3   |             0 . 8 5   |                     3 . 1 8 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |         3 8 0 1   |       3 7 . 5 1   |         2 9 2 . 1 6   |     1 4 2 5 8 3 . 2 0   |             0 . 6 4   |                     2 . 3 8 
 
 ( 2 0   r o w s ) 
 
 
 
 T i m e :   4 4 . 9 9 7   m s 
 
 
 
 5 .   B A S E I T E M S   T A B L E   Q U E R I E S   A N A L Y S I S 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 F o c u s i n g   o n   B a s e I t e m s   t a b l e   ( w h e r e   1 1 0 - s e c o n d   q u e r i e s   o c c u r ) 
 
 
 
                                                                                                                                           q u e r y _ p r e v i e w                                                                                                                                             |     c a l l s     |   a v g _ m s     |     m a x _ m s       |   m i n _ m s     |     t o t a l _ m s     |   r o w s _ r e t u r n e d   |   a v g _ r o w s _ p e r _ c a l l   |   p e r f o r m a n c e _ r a t i n g     
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - - + - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             4 8   |   4 4 4 2 . 7 5   |   1 1 0 0 4 8 . 0 0   |         0 . 0 6   |     2 1 3 2 5 1 . 8 9   |                 6 8 6 2 4 5   |                     1 4 2 9 6 . 7 7   |   a"    C R I T I C A L   ( > 1 0 0 s ) 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             7 6   |   3 2 2 9 . 7 2   |     3 6 3 3 7 . 2 1   |         4 . 9 7   |     2 4 5 4 5 8 . 4 7   |                 1 0 2 2 7 0   |                       1 3 4 5 . 6 6   |     )"U%   S L O W   ( > 1 0 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             5 2   |   7 8 6 6 . 0 5   |     2 6 0 9 6 . 6 5   |   5 0 0 6 . 5 1   |     4 0 9 0 3 4 . 5 6   |                   3 6 5 7 4   |                         7 0 3 . 3 5   |     )"U%   S L O W   ( > 1 0 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             5 3   |   5 9 8 6 . 9 6   |     1 2 8 9 0 . 7 2   |   5 0 7 2 . 2 2   |     3 1 7 3 0 8 . 8 9   |                   1 6 6 1 7   |                         3 1 3 . 5 3   |     )"U%   S L O W   ( > 1 0 s ) 
 
   U P D A T E   l i b r a r y . " B a s e I t e m s "   S E T   " A l b u m "   =   $ 1 ,   " A l b u m A r t i s t s "   =   $ 2 ,   " A r t i s t s "   =   $ 3 ,   " A u d i o "   =   $ 4 ,   " C h a n n e l I d "   =   $ 5 ,   " C l e a n N a m e "   =   $ 6 ,   " C o m m u n i t y R a t i n g "     |     4 0 6 5 1 3   |         1 . 0 2   |       9 4 2 6 . 4 8   |         0 . 0 5   |     4 1 2 6 6 9 . 1 9   |                 4 0 6 5 1 3   |                             1 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             1 0   |   2 2 0 6 . 5 2   |       9 4 2 1 . 8 6   |     2 5 1 . 4 7   |       2 2 0 6 5 . 2 2   |                         4 2   |                             4 . 2 0   |       M O D E R A T E   ( > 1 s ) 
 
   V A C U U M   A N A L Y Z E   " l i b r a r y " . " B a s e I t e m s "                                                                                                                                                                                                                                       |               4   |   5 2 4 4 . 5 0   |       9 2 7 0 . 5 6   |   3 1 4 8 . 6 0   |       2 0 9 7 8 . 0 0   |                           0   |                             0 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   C O P Y   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " T y p e " ,   " D a t a " ,   " P a t h " ,   " S t a r t D a t e " ,   " E n d D a t e " ,   " C h a n n e l I d " ,   " I s M o v i e " ,   " C o m m u n i t y R a t i n g " ,   " C u s t o m R a t i n g " ,   " I n d e x N u m b e   |               9   |   4 0 2 0 . 6 3   |       9 0 6 3 . 5 0   |   2 5 3 8 . 7 4   |       3 6 1 8 5 . 6 4   |               1 1 0 8 5 4 2   |                   1 2 3 1 7 1 . 3 3   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |       7 9 5 7 1   |         9 . 2 1   |       7 6 3 5 . 5 0   |         0 . 0 4   |     7 3 2 5 6 7 . 2 1   |             1 0 1 9 0 4 6 9   |                         1 2 8 . 0 7   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 5 . " I d " ,   b 5 . " A l b u m " ,   b 5 . " A l b u m A r t i s t s " ,   b 5 . " A r t i s t s " ,   b 5 . " A u d i o " ,   b 5 . " C h a n n e l I d " ,   b 5 . " C l e a n N a m e " ,   b 5 . " C o m m u n i t y R a t i n g " ,   b 5 . " C r i t i c R a t i n g " ,   b 5 . "   |             3 3   |     7 4 0 . 0 5   |       7 2 1 5 . 2 9   |         0 . 1 8   |       2 4 4 2 1 . 5 2   |                       2 9 1   |                             8 . 8 2   |       M O D E R A T E   ( > 1 s ) 
 
   A N A L Y Z E   l i b r a r y . " B a s e I t e m s "                                                                                                                                                                                                                                                         |               2   |   3 5 9 8 . 8 5   |       7 1 9 1 . 2 3   |         6 . 4 6   |         7 1 9 7 . 6 9   |                           0   |                             0 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             5 3   |     3 2 3 . 4 5   |       6 8 5 9 . 7 1   |         4 . 8 7   |       1 7 1 4 2 . 8 9   |                   2 1 8 1 3   |                         4 1 1 . 5 7   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |               5   |   5 7 1 3 . 8 8   |       6 5 5 0 . 2 6   |   5 2 3 6 . 6 7   |       2 8 5 6 9 . 3 9   |                     7 0 6 9   |                       1 4 1 3 . 8 0   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             4 5   |   1 0 2 6 . 6 4   |       6 5 4 1 . 0 0   |     1 9 4 . 0 7   |       4 6 1 9 8 . 7 5   |                         4 5   |                             1 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |           1 0 2   |     3 6 4 . 8 1   |       6 2 5 3 . 6 6   |         0 . 0 5   |       3 7 2 1 0 . 1 7   |                       1 1 1   |                             1 . 0 9   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |           1 3 6   |     4 7 6 . 0 8   |       5 4 5 7 . 7 0   |         0 . 1 1   |       6 4 7 4 7 . 3 9   |                   4 0 0 4 0   |                         2 9 4 . 4 1   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             2 0   |   1 0 0 6 . 4 5   |       4 5 9 5 . 5 4   |         0 . 0 4   |       2 0 1 2 9 . 0 3   |                         3 6   |                             1 . 8 0   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |             1 0   |   1 4 9 8 . 4 2   |       4 2 5 4 . 2 9   |     2 2 3 . 4 7   |       1 4 9 8 4 . 1 8   |                           0   |                             0 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             4 5   |   1 2 6 2 . 5 9   |       3 9 0 1 . 6 4   |     1 5 8 . 5 3   |       5 6 8 1 6 . 6 0   |                       1 5 6   |                             3 . 4 7   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 2 . " I d " ,   b 2 . " A l b u m " ,   b 2 . " A l b u m A r t i s t s " ,   b 2 . " A r t i s t s " ,   b 2 . " A u d i o " ,   b 2 . " C h a n n e l I d " ,   b 2 . " C l e a n N a m e " ,   b 2 . " C o m m u n i t y R a t i n g " ,   b 2 . " C r i t i c R a t i n g " ,   b 2 . "   |       3 7 2 8 3   |         6 . 5 3   |       3 8 4 3 . 1 7   |         0 . 1 3   |     2 4 3 3 3 5 . 2 1   |                 1 1 1 5 2 4   |                             2 . 9 9   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             3 3   |   2 6 4 3 . 2 2   |       3 8 3 9 . 3 5   |     2 8 2 . 9 5   |       8 7 2 2 6 . 4 0   |                         9 3   |                             2 . 8 2   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             1 1   |     6 9 3 . 1 6   |       3 6 9 2 . 3 2   |         0 . 2 0   |         7 6 2 4 . 8 0   |                           6   |                             0 . 5 5   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " S e r i e s P r e s e n t a t i o n U n i q u e K e y "                                                                                                                                                                                                                                 + |           1 5 3   |     2 1 8 . 8 3   |       3 3 2 3 . 9 6   |         0 . 0 2   |       3 3 4 8 0 . 5 9   |                   3 7 2 2 8   |                         2 4 3 . 3 2   |       M O D E R A T E   ( > 1 s ) 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   I N N E R   J O I N   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   u . " I t e m I d " ,   u . " U s e r I d " ,   u . " L a s t P l a y e d D a t e "                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           F R O M   l i b r a                                                                                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   I N S E R T   I N T O   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " A l b u m " ,   " A l b u m A r t i s t s " ,   " A r t i s t s " ,   " A u d i o " ,   " C h a n n e l I d " ,   " C l e a n N a m e " ,   " C o m m u n i t y R a t i n g " ,   " C r i t i c R a t i n g " ,   " C u s t   |     1 3 2 7 9 2   |         1 . 4 4   |       3 1 7 1 . 8 3   |         0 . 2 1   |     1 9 0 8 3 9 . 2 3   |                 1 3 2 7 9 2   |                             1 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             3 3   |   1 7 4 2 . 2 1   |       2 5 6 6 . 9 8   |     3 5 1 . 0 4   |       5 7 4 9 2 . 8 7   |                         3 3   |                             1 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             6 7   |     5 9 6 . 0 8   |       2 5 2 9 . 1 9   |         0 . 0 9   |       3 9 9 3 7 . 5 0   |                     8 9 3 5   |                         1 3 3 . 3 6   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   c . " I t e m I d " ,   c . " C h a p t e r I n d e x " ,   c . " I m a g e D a t e M o d i f i e d " ,   c . " I m a g e P a t h " ,   c . " N a m e " ,   c . " S t a r t P o s i t i o n T i c k s " ,   b . " P a t h "   A S   " b a s e I t e m P a t h "                               + |         5 1 2 2   |         0 . 8 0   |       2 3 3 7 . 8 0   |         0 . 0 3   |         4 1 0 8 . 8 8   |                   3 0 2 3 4   |                             5 . 9 0   |       M O D E R A T E   ( > 1 s ) 
 
   F R O M   l i b r a r y . "                                                                                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |               1   |   2 2 6 9 . 4 2   |       2 2 6 9 . 4 2   |   2 2 6 9 . 4 2   |         2 2 6 9 . 4 2   |                 1 1 5 7 9 7   |                   1 1 5 7 9 7 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             2 2   |     1 9 8 . 0 8   |       2 2 6 3 . 8 6   |         0 . 3 8   |         4 3 5 7 . 8 5   |                           1   |                             0 . 0 5   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |         7 1 7 8   |       4 7 . 9 6   |       1 8 7 9 . 0 4   |         0 . 0 5   |     3 4 4 2 6 5 . 6 9   |               4 5 1 6 1 1 3   |                         6 2 9 . 1 6   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |       1 3 0 9 1   |     1 2 2 . 8 8   |       1 8 0 2 . 9 2   |         0 . 0 5   |   1 6 0 8 6 0 2 . 6 5   |             2 0 8 8 0 9 1 6   |                       1 5 9 5 . 0 6   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |             2 3   |     4 0 0 . 2 1   |       1 4 9 1 . 9 3   |       8 1 . 3 8   |         9 2 0 4 . 9 1   |                       4 0 6   |                           1 7 . 6 5   |       M O D E R A T E   ( > 1 s ) 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |       2 1 2 5 7   |         4 . 8 2   |       1 3 7 7 . 3 0   |         0 . 0 6   |     1 0 2 4 5 0 . 4 2   |                 6 8 8 1 7 4   |                           3 2 . 3 7   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   (                                                                                                                                                                                                                                                                                             + |               3   |     7 1 7 . 0 8   |       1 2 0 4 . 7 5   |     3 5 7 . 9 3   |         2 1 5 1 . 2 3   |                       1 3 8   |                           4 6 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
           S E L E C T   i 5 . " V a l u e "                                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           F R O M   l i b r a r y . " I t e m V a l u e s M a p "   A S   i 2                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           I N N E R   J O I N   l i b r a r y . " I t e m V a l u e s "   A S   i 3   O N   i 2 . " I t e m V a l u e I d "   =   i 3 . " I t e m V a l u e I d "                                                                                                                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             4 3   |       4 8 . 8 8   |       1 1 8 5 . 6 0   |         1 . 0 6   |         2 1 0 1 . 6 4   |                     6 7 4 8   |                         1 5 6 . 9 3   |       M O D E R A T E   ( > 1 s ) 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |           5 5 8   |       2 4 . 2 5   |       1 0 8 8 . 9 6   |         0 . 1 3   |       1 3 5 3 2 . 1 8   |                 1 8 5 4 3 1   |                         3 3 2 . 3 1   |       M O D E R A T E   ( > 1 s ) 
 
   C R E A T E   I N D E X   C O N C U R R E N T L Y   I F   N O T   E X I S T S   " I X _ B a s e I t e m s _ P r e s e n t a t i o n K e y s _ C o m p o s i t e "   \ r                                                                                                                                     + |               1   |   1 0 4 0 . 7 9   |       1 0 4 0 . 7 9   |   1 0 4 0 . 7 9   |         1 0 4 0 . 7 9   |                           0   |                             0 . 0 0   |       M O D E R A T E   ( > 1 s ) 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " P r e s e n t a t i o n U n i q u e K e y " ,   " S e r i e s P r e s e n t a t i                                                                                                                                                                           |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |           1 5 8   |     2 4 5 . 0 9   |         9 5 8 . 3 3   |         2 . 6 1   |       3 8 7 2 4 . 9 2   |                 6 3 6 4 7 2   |                       4 0 2 8 . 3 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             9 7   |       6 8 . 5 2   |         7 3 5 . 4 8   |       2 3 . 6 6   |         6 6 4 6 . 7 5   |                         9 7   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                                 + |           1 7 0   |       3 0 . 9 2   |         7 1 9 . 1 7   |         0 . 1 3   |         5 2 5 6 . 1 3   |                       3 5 9   |                             2 . 1 1   |       F A S T 
 
   F R O M   (                                                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   D I S T I N C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |           1 3 6   |       9 1 . 7 5   |         6 8 5 . 0 5   |       3 7 . 1 1   |       1 2 4 7 8 . 6 2   |                   6 7 0 1 3   |                         4 9 2 . 7 4   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             7 2   |       9 9 . 0 6   |         6 4 7 . 5 8   |       4 3 . 1 2   |         7 1 3 2 . 0 4   |                   3 8 2 0 2   |                         5 3 0 . 5 8   |       F A S T 
 
   S E L E C T   (                                                                                                                                                                                                                                                                                             + |               3   |     4 0 1 . 2 3   |         6 3 5 . 3 2   |       5 5 . 4 0   |         1 2 0 3 . 6 8   |                         4 0   |                           1 3 . 3 3   |       F A S T 
 
           S E L E C T   i 5 . " V a l u e "                                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           F R O M   l i b r a r y . " I t e m V a l u e s M a p "   A S   i 2                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           I N N E R   J O I N   l i b r a r y . " I t e m V a l u e s "   A S   i 3   O N   i 2 . " I t e m V a l u e I d "   =   i 3 . " I t e m V a l u e I d "                                                                                                                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             5 9   |     3 1 3 . 8 6   |         6 0 0 . 0 0   |       6 1 . 1 5   |       1 8 5 1 7 . 7 4   |                   7 5 4 3 8   |                       1 2 7 8 . 6 1   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |             1 8   |     3 1 4 . 7 4   |         4 8 6 . 0 3   |     1 1 7 . 8 6   |         5 6 6 5 . 2 4   |                       2 5 6   |                           1 4 . 2 2   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               5   |     2 3 0 . 2 8   |         4 8 5 . 3 0   |     1 5 2 . 2 6   |         1 1 5 1 . 4 2   |                     2 2 0 0   |                         4 4 0 . 0 0   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             1 5   |       9 3 . 0 5   |         4 5 1 . 7 8   |       3 6 . 5 7   |         1 3 9 5 . 7 5   |                     6 9 0 6   |                         4 6 0 . 4 0   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               2   |     4 4 3 . 3 8   |         4 4 4 . 0 0   |     4 4 2 . 7 7   |           8 8 6 . 7 7   |                         3 2   |                           1 6 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               3   |     4 1 3 . 6 1   |         4 2 4 . 4 9   |     4 0 1 . 6 8   |         1 2 4 0 . 8 2   |                         3 6   |                           1 2 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             1 0   |     1 1 4 . 1 4   |         3 9 9 . 2 4   |       4 5 . 4 6   |         1 1 4 1 . 3 8   |                     4 7 6 0   |                         4 7 6 . 0 0   |       F A S T 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             5 0   |       1 1 . 9 4   |         3 5 7 . 7 5   |         0 . 3 3   |           5 9 7 . 1 1   |                     4 2 9 2   |                           8 5 . 8 4   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               2   |     2 7 1 . 9 4   |         3 4 9 . 4 0   |     1 9 4 . 4 8   |           5 4 3 . 8 9   |                         2 4   |                           1 2 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   C O N C U R R E N T L Y   I F   N O T   E X I S T S   " I X _ B a s e I t e m s _ S e r i e s P r e s e n t a t i o n U n i q u e K e y "   \ r                                                                                                                                   + |               1   |     3 4 5 . 0 5   |         3 4 5 . 0 5   |     3 4 5 . 0 5   |           3 4 5 . 0 5   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " S e r i e s P r e s e n t a t i o n U n i q u e K e y " ) \ r                                                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   " S e                                                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 4 . " I d " ,   b 4 . " A l b u m " ,   b 4 . " A l b u m A r t i s t s " ,   b 4 . " A r t i s t s " ,   b 4 . " A u d i o " ,   b 4 . " C h a n n e l I d " ,   b 4 . " C l e a n N a m e " ,   b 4 . " C o m m u n i t y R a t i n g " ,   b 4 . " C r i t i c R a t i n g " ,   b 4 . "   |   2 8 8 9 7 4 9   |         0 . 3 1   |         3 3 5 . 5 9   |         0 . 0 2   |     9 0 1 5 1 1 . 9 8   |               5 6 8 1 9 8 6   |                             1 . 9 7   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               5   |     1 6 3 . 0 2   |         3 1 2 . 3 2   |       4 2 . 9 3   |           8 1 5 . 0 8   |                           5   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 2 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 2                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |         3 8 0 1   |       3 7 . 5 1   |         2 9 2 . 1 6   |         0 . 2 7   |     1 4 2 5 8 3 . 2 0   |               2 0 5 3 2 3 6   |                         5 4 0 . 1 8   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             4 1   |       2 3 . 8 6   |         2 7 7 . 3 1   |         0 . 3 8   |           9 7 8 . 3 2   |                         4 1   |                             1 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   C O N C U R R E N T L Y   I F   N O T   E X I S T S   " I X _ B a s e I t e m s _ T y p e _ T o p P a r e n t I d "   \ r                                                                                                                                                         + |               1   |     2 7 0 . 7 3   |         2 7 0 . 7 3   |     2 7 0 . 7 3   |           2 7 0 . 7 3   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " T o p P a r e n t I d " ) \ r                                                                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   " T o p P a r e n t I d "   I S   N O T   N                                                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   C O N C U R R E N T L Y   I F   N O T   E X I S T S   " I X _ B a s e I t e m s _ S e r i e s _ G r o u p i n g "   \ r                                                                                                                                                           + |               1   |     2 6 8 . 9 0   |         2 6 8 . 9 0   |     2 6 8 . 9 0   |           2 6 8 . 9 0   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " T o p P a r e n t I d " ,   " P r e s e n t a t i o n U n i q u e K e y " ,   " I d " )                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             1 4   |       7 0 . 7 7   |         2 6 5 . 2 7   |         2 . 7 6   |           9 9 0 . 8 0   |                     3 2 5 6   |                         2 3 2 . 5 7   |       F A S T 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             5 2   |       2 5 . 1 2   |         2 6 0 . 9 7   |         0 . 9 9   |         1 3 0 6 . 2 4   |                     9 2 4 3   |                         1 7 7 . 7 5   |       F A S T 
 
   S E L E C T   b 5 . " I d " ,   b 5 . " A l b u m " ,   b 5 . " A l b u m A r t i s t s " ,   b 5 . " A r t i s t s " ,   b 5 . " A u d i o " ,   b 5 . " C h a n n e l I d " ,   b 5 . " C l e a n N a m e " ,   b 5 . " C o m m u n i t y R a t i n g " ,   b 5 . " C r i t i c R a t i n g " ,   b 5 . "   |               5   |     1 4 2 . 5 3   |         2 5 3 . 8 2   |       7 8 . 5 8   |           7 1 2 . 6 6   |                     3 6 1 8   |                         7 2 3 . 6 0   |       F A S T 
 
   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                                 + |             1 2   |     1 3 1 . 7 8   |         2 3 9 . 3 1   |       7 1 . 3 4   |         1 5 8 1 . 3 6   |                       3 6 0   |                           3 0 . 0 0   |       F A S T 
 
   F R O M   (                                                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   D I S T I N C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                                 + |               3   |     1 7 8 . 7 3   |         2 3 4 . 6 3   |     1 4 7 . 0 8   |           5 3 6 . 1 9   |                           0   |                             0 . 0 0   |       F A S T 
 
   F R O M   (                                                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   D I S T I N C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             7 4   |       2 9 . 2 4   |         2 2 9 . 0 7   |         3 . 4 3   |         2 1 6 3 . 8 8   |                   3 1 3 7 4   |                         4 2 3 . 9 7   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |               9   |     1 1 8 . 5 6   |         1 6 5 . 4 6   |       8 5 . 2 5   |         1 0 6 7 . 0 6   |                     6 9 3 8   |                         7 7 0 . 8 9   |       F A S T 
 
   e x p l a i n   a n a l y z e   S E L E C T   \ r                                                                                                                                                                                                                                                           + |               1   |     1 5 1 . 0 7   |         1 5 1 . 0 7   |     1 5 1 . 0 7   |           1 5 1 . 0 7   |                           0   |                             0 . 0 0   |       F A S T 
 
           b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   \ r                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
           b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   e x p l a i n   a n a l y z e   S E L E C T   \ r                                                                                                                                                                                                                                                           + |               1   |     1 3 6 . 3 5   |         1 3 6 . 3 5   |     1 3 6 . 3 5   |           1 3 6 . 3 5   |                     5 8 0 2   |                       5 8 0 2 . 0 0   |       F A S T 
 
           b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   \ r                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
           b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             3 7   |       2 9 . 8 9   |         1 3 6 . 0 5   |         0 . 2 8   |         1 1 0 5 . 7 9   |                     3 5 2 7   |                           9 5 . 3 2   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |       3 7 2 4 2   |         0 . 3 2   |         1 3 3 . 6 1   |         0 . 0 3   |       1 1 8 4 7 . 7 2   |                     1 0 1 0   |                             0 . 0 3   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |               8   |       9 5 . 0 9   |         1 2 0 . 0 3   |         7 . 9 6   |           7 6 0 . 7 0   |                     5 3 6 1   |                         6 7 0 . 1 3   |       F A S T 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |               5   |       5 3 . 9 7   |         1 0 6 . 8 1   |       2 8 . 1 4   |           2 6 9 . 8 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             6 8   |       1 1 . 3 8   |           9 1 . 3 3   |         1 . 7 4   |           7 7 4 . 0 8   |                     7 0 9 0   |                         1 0 4 . 2 6   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             9 1   |       1 3 . 4 6   |           7 9 . 1 4   |         1 . 1 5   |         1 2 2 4 . 4 9   |                         9 1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               8   |         9 . 6 2   |           7 5 . 6 9   |         0 . 0 6   |             7 6 . 9 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " P a r e n t I d "   =   A N Y   ( $ 1 )   O R   ( b . " P a r e n t I d "   I S   N U L L   A N D   a r r a y _ p o s i t i o n ( $ 1 ,   $ 2 )   I S   N O T   N U L L )                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |       3 7 2 8 3   |         0 . 2 1   |           6 5 . 6 8   |         0 . 0 3   |         7 8 7 7 . 4 5   |                           5   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |           4 5 6   |         1 . 3 7   |           5 0 . 1 8   |         0 . 0 6   |           6 2 4 . 7 7   |                         1 6   |                             0 . 0 4   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   ( b . " P a r e n t I d "   =   A N Y   ( $ 1 )   O R   ( b . " P a r e n t I d "   I S   N U L L   A N D   a r r a y _ p o s i t i o n ( $ 1 ,   $ 2 )   I S   N O T   N U L L ) )   A N D   ( b . " I                                                                                           |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |           7 8 6   |         0 . 3 4   |           4 0 . 6 4   |         0 . 0 5   |           2 6 3 . 3 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |         5 8 0 0   |         0 . 1 7   |           3 9 . 4 6   |         0 . 0 3   |           9 7 2 . 4 4   |                     5 8 0 0   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " T y p e "   =   $ 3   A N D   b . " I s V i r t u a l I t e m "   =   $ 1   A N D   b . " S e r i e s P r e s e n t a t i o n U n i q u e K e y "   =   $ 2                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                                 + |               8   |         9 . 8 7   |           3 5 . 3 4   |         0 . 1 0   |             7 8 . 9 2   |                         3 2   |                             4 . 0 0   |       F A S T 
 
   F R O M   (                                                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   D I S T I N C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                                 + |               4   |       1 3 . 0 7   |           3 4 . 8 3   |         0 . 1 2   |             5 2 . 2 6   |                         1 6   |                             4 . 0 0   |       F A S T 
 
   F R O M   (                                                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   D I S T I N C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             5 8   |       1 6 . 1 2   |           3 0 . 6 0   |         7 . 3 7   |           9 3 5 . 0 8   |                   1 0 4 7 9   |                         1 8 0 . 6 7   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               2   |       1 7 . 8 8   |           2 7 . 5 5   |         8 . 2 1   |             3 5 . 7 5   |                         3 0   |                           1 5 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " T y p e "   A S   " K e y " ,   c o u n t ( * ) : : i n t   A S   " C o u n t "                                                                                                                                                                                                         + |             1 2   |       1 0 . 3 9   |           2 6 . 1 4   |         0 . 7 7   |           1 2 4 . 6 8   |                         3 2   |                             2 . 6 7   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " T y p e "   =   A N Y   ( $ 1 )   A N D   E X I S T S   (                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   $ 3                                                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           F R O M   l i b r a r y                                                                                                                                                                                                                                                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   C O N C U R R E N T L Y   I F   N O T   E X I S T S   " I X _ B a s e I t e m s _ P r e s e n t a t i o n U n i q u e K e y "   \ r                                                                                                                                               + |               1   |       2 5 . 3 2   |           2 5 . 3 2   |       2 5 . 3 2   |             2 5 . 3 2   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " P r e s e n t a t i o n U n i q u e K e y " )   \ r                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   " P r e s e n t a t i o n U                                                                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               3   |       1 0 . 0 4   |           2 0 . 3 1   |         4 . 6 4   |             3 0 . 1 1   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b 2 . " I d " ,   b 2 . " A l b u m " ,   b 2 . " A l b u m A r t i s t s " ,   b 2 . " A r t i s t s " ,   b 2 . " A u d i o " ,   b 2 . " C h a n n e l I d " ,   b 2 . " C l e a n N a m e " ,   b 2 . " C o m m u n i t y R a t i n g " ,   b 2 . " C r i t i c R a t i n g " ,   b 2 . "   |             5 5   |         0 . 8 6   |           1 9 . 5 1   |         0 . 0 7   |             4 7 . 2 2   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             5 8   |         7 . 6 4   |           1 8 . 0 8   |         3 . 2 9   |           4 4 3 . 2 0   |                         5 8   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 5 . " I d " ,   b 5 . " A l b u m " ,   b 5 . " A l b u m A r t i s t s " ,   b 5 . " A r t i s t s " ,   b 5 . " A u d i o " ,   b 5 . " C h a n n e l I d " ,   b 5 . " C l e a n N a m e " ,   b 5 . " C o m m u n i t y R a t i n g " ,   b 5 . " C r i t i c R a t i n g " ,   b 5 . "   |               3   |         9 . 9 4   |           1 5 . 3 3   |         3 . 0 9   |             2 9 . 8 1   |                       2 8 2   |                           9 4 . 0 0   |       F A S T 
 
   S E L E C T   N O T   E X I S T S   (                                                                                                                                                                                                                                                                       + |         1 2 0 0   |         0 . 8 3   |           1 5 . 0 0   |         0 . 0 4   |           9 9 4 . 3 0   |                     1 2 0 0   |                             1 . 0 0   |       F A S T 
 
           S E L E C T   $ 3                                                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           W H E R E   ( b . " P a r e n t I d "   =   A N Y   ( $ 1 )   O R   ( b . " P a r e n t I d "   I S   N U L L   A N D   a r r a y _ p o s i t i o n ( $ 1 ,                                                                                                                                           |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 5 . " I d " ,   b 5 . " A l b u m " ,   b 5 . " A l b u m A r t i s t s " ,   b 5 . " A r t i s t s " ,   b 5 . " A u d i o " ,   b 5 . " C h a n n e l I d " ,   b 5 . " C l e a n N a m e " ,   b 5 . " C o m m u n i t y R a t i n g " ,   b 5 . " C r i t i c R a t i n g " ,   b 5 . "   |             1 3   |         4 . 5 5   |           1 1 . 8 3   |         1 . 4 4   |             5 9 . 1 3   |                       3 0 5   |                           2 3 . 4 6   |       F A S T 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |             6 9   |         0 . 4 8   |           1 1 . 6 8   |         0 . 1 2   |             3 3 . 0 8   |                         6 8   |                             0 . 9 9   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |               3   |         8 . 8 4   |           1 1 . 1 9   |         7 . 4 4   |             2 6 . 5 2   |                         2 1   |                             7 . 0 0   |       F A S T 
 
   C R E A T E   T A B L E   l i b r a r y . " B a s e I t e m s "   (                                                                                                                                                                                                                                         + |               1   |       1 1 . 0 6   |           1 1 . 0 6   |       1 1 . 0 6   |             1 1 . 0 6   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                               + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " T y p e "   t e x t   N O T   N U L L ,                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " D a t a "   t e x t ,                                                                                                                                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " P a t h "   t e x t ,                                                                                                                                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " S t a r t D a t e "   t i m e s t a m p   w i t h                                                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   C O U N T ( * )   F R O M   ( S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b   |               1   |       1 0 . 9 5   |           1 0 . 9 5   |       1 0 . 9 5   |             1 0 . 9 5   |                           1   |                             1 . 0 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               3   |         8 . 9 3   |             9 . 6 4   |         8 . 5 5   |             2 6 . 7 8   |                           3   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             1 6   |         2 . 7 8   |             8 . 9 0   |         0 . 8 1   |             4 4 . 5 1   |                         1 6   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 2 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 2                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " M e d i a S t r e a m I n f o s "   (                                                                                                                                                                                                                           + |               1   |         8 . 0 5   |             8 . 0 5   |         8 . 0 5   |               8 . 0 5   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " S t r e a m I n d e x "   i n t e g e r   N O T   N U L L ,                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " S t r e a m T y p e "   i n t e g e r   N O T   N U L L ,                                                                                                                                                                                                                                         + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " C o d e                                                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " P e o p l e B a s e I t e m M a p "   (                                                                                                                                                                                                                         + |               1   |         7 . 4 4   |             7 . 4 4   |         7 . 4 4   |               7 . 4 4   |                           0   |                             0 . 0 0   |       F A S T 
 
           " R o l e "   t e x t   N O T   N U L L ,                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " P e o p l e I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " S o r t O r d e r "   i n t e g e r                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   E X I S T S   (                                                                                                                                                                                                                                                                               + |     3 8 3 5 7 0   |         0 . 0 6   |             6 . 6 7   |         0 . 0 2   |       2 3 1 3 7 . 6 1   |                 3 8 3 5 7 0   |                             1 . 0 0   |       F A S T 
 
           S E L E C T   $ 2                                                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           W H E R E   b . " I d "   =   $ 1 )                                                                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |     7 9 9 0 6 9   |         0 . 0 7   |             6 . 1 4   |         0 . 0 0   |       5 5 6 9 0 . 0 6   |               1 8 3 1 9 6 4   |                             2 . 2 9   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   =   A N Y   ( $ 1 )                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " C h a p t e r s "   (                                                                                                                                                                                                                                           + |               1   |         6 . 1 3   |             6 . 1 3   |         6 . 1 3   |               6 . 1 3   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " C h a p t e r I n d e x "   i n t e g e r   N O T   N U L L ,                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " S t a r t P o s i t i o n T i c k s "   b i g i n t   N O T   N U L L ,                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " N a m e                                                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " B a s e I t e m I m a g e I n f o s "   (                                                                                                                                                                                                                       + |               1   |         6 . 0 6   |             6 . 0 6   |         6 . 0 6   |               6 . 0 6   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                               + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " P a t h "   t e x t   N O T   N U L L ,                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " D a t e M o d i f i e d "   t i m e s t a m p   w i t h   t i m e   z o n e ,                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I m a g e T                                                                                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " B a s e I t e m P r o v i d e r s "   (                                                                                                                                                                                                                         + |               1   |         5 . 9 4   |             5 . 9 4   |         5 . 9 4   |               5 . 9 4   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " P r o v i d e r I d "   t e x t   N O T   N U L L ,                                                                                                                                                                                                                                               + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " P r o v i d e r V a l u e "   t e x t   N O T   N U L L ,                                                                                                                                                                                                                                         + |                   |                   |                       |                   |                         |                               |                                       |   
 
           C O N S T R A I                                                                                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " K e y f r a m e D a t a "   (                                                                                                                                                                                                                                   + |               1   |         5 . 8 3   |             5 . 8 3   |         5 . 8 3   |               5 . 8 3   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " T o t a l D u r a t i o n "   b i g i n t   N O T   N U L L ,                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " K e y f r a m e T i c k s "   b i g i n t [ ] ,                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           C O N S T R A I N T   " P                                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " A t t a c h m e n t S t r e a m I n f o s "   (                                                                                                                                                                                                                 + |               1   |         5 . 5 5   |             5 . 5 5   |         5 . 5 5   |               5 . 5 5   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I n d e x "   i n t e g e r   N O T   N U L L ,                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " C o d e c "   t e x t ,                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " C o d e c T a g "   t e x t ,                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " C                                                                                                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b i . *   F R O M   " l i b r a r y " . " B a s e I t e m s "   A S   b i                                                                                                                                                                                                                       |               1   |         5 . 4 8   |             5 . 4 8   |         5 . 4 8   |               5 . 4 8   |                       2 0 0   |                         2 0 0 . 0 0   |       F A S T 
 
   C R E A T E   T A B L E   l i b r a r y . " I t e m V a l u e s M a p "   (                                                                                                                                                                                                                                 + |               1   |         5 . 3 9   |             5 . 3 9   |         5 . 3 9   |               5 . 3 9   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I t e m V a l u e I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                             + |                   |                   |                       |                   |                         |                               |                                       |   
 
           C O N S T R A I N T   " P K _ I t e m V a l u e s M a p "   P R I M A R Y   K E Y   ( " I t                                                                                                                                                                                                           |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " B l u r h a s h " ,   b 0 . " D a t e M o d i f i e d " ,   b 0 . " H e i g h t " ,   b 0 . " I m a g e T y p e " ,   b 0 . " I t e m I d " ,   b 0 . " P a t h " ,   b 0 . " W i d t h " ,   b . " I d "                                                           + |           1 7 6   |         0 . 6 7   |             5 . 2 4   |         0 . 0 4   |           1 1 7 . 6 8   |                     8 7 7 0   |                           4 9 . 8 3   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S                                                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " A n c e s t o r I d s "   (                                                                                                                                                                                                                                     + |               1   |         4 . 7 5   |             4 . 7 5   |         4 . 7 5   |               4 . 7 5   |                           0   |                             0 . 0 0   |       F A S T 
 
           " P a r e n t I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           C O N S T R A I N T   " P K _ A n c e s t o r I d s "   P R I M A R Y   K E Y   ( " I t e m I                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |             4 2   |         1 . 3 5   |             4 . 2 9   |         0 . 1 1   |             5 6 . 8 9   |                       6 9 0   |                           1 6 . 4 3   |       F A S T 
 
   C R E A T E   T A B L E   l i b r a r y . " U s e r D a t a "   (                                                                                                                                                                                                                                           + |               1   |         4 . 1 4   |             4 . 1 4   |         4 . 1 4   |               4 . 1 4   |                           0   |                             0 . 0 0   |       F A S T 
 
           " C u s t o m D a t a K e y "   t e x t   N O T   N U L L ,                                                                                                                                                                                                                                         + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " U s e r I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " R a t i n g "   d o u b l e   p r e c i                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               5   |         1 . 7 4   |             4 . 1 4   |         0 . 3 7   |               8 . 6 9   |                           5   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " B a s e I t e m T r a i l e r T y p e s "   (                                                                                                                                                                                                                   + |               1   |         4 . 1 0   |             4 . 1 0   |         4 . 1 0   |               4 . 1 0   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I d "   i n t e g e r   N O T   N U L L ,                                                                                                                                                                                                                                                         + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           C O N S T R A I N T   " P K _ B a s e I t e m T r a i l e r T y p e s "   P R I M A R Y                                                                                                                                                                                                               |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   T A B L E   l i b r a r y . " B a s e I t e m M e t a d a t a F i e l d s "   (                                                                                                                                                                                                               + |               1   |         3 . 8 9   |             3 . 8 9   |         3 . 8 9   |               3 . 8 9   |                           0   |                             0 . 0 0   |       F A S T 
 
           " I d "   i n t e g e r   N O T   N U L L ,                                                                                                                                                                                                                                                         + |                   |                   |                       |                   |                         |                               |                                       |   
 
           " I t e m I d "   u u i d   N O T   N U L L ,                                                                                                                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
           C O N S T R A I N T   " P K _ B a s e I t e m M e t a d a t a F i e l d s "   P R I M                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |           1 7 8   |         0 . 6 7   |             3 . 3 7   |         0 . 0 5   |           1 1 8 . 5 0   |                     1 5 5 2   |                             8 . 7 2   |       F A S T 
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |             3 0   |         0 . 1 8   |             2 . 4 8   |         0 . 0 4   |               5 . 2 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |           3 4 4   |         0 . 2 9   |             2 . 3 6   |         0 . 0 5   |           1 0 0 . 3 2   |                           0   |                             0 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " P a r e n t I d "   I N   ( $ 1   / * ,   . . .   * / )   A N D   ( b . " I s F o l d e r "   O R   b . " I s V i r t u a l I t e m " )                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ c o m m u n i t y r a t i n g _ i d x   \ r                                                                                                                                                                                       + |               1   |         2 . 1 3   |             2 . 1 3   |         2 . 1 3   |               2 . 1 3   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " C o m m u n i t y R a t i n g "   D E S C )                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   u . " I t e m I d " ,   u . " U s e r I d " ,   u . " C u s t o m D a t a K e y " ,   u . " A u d i o S t r e a m I n d e x " ,   u . " I s F a v o r i t e " ,   u . " L a s t P l a y e d D a t e " ,   u . " L i k e s " ,   u . " P l a y C o u n t " ,   u . " P l a y b a c k P o s i t   |           1 7 8   |         0 . 2 9   |             1 . 9 9   |         0 . 0 4   |             5 2 . 3 4   |                       1 1 4   |                             0 . 6 4   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               1   |         1 . 8 9   |             1 . 8 9   |         1 . 8 9   |               1 . 8 9   |                           1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   W H E R E                                                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   i d x _ b a s e i t e m s _ t o p p a r e n t i d _ i s f o l d e r \ r                                                                                                                                                                               + |               1   |         1 . 8 6   |             1 . 8 6   |         1 . 8 6   |               1 . 8 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " T o p P a r e n t I d " ,   " I s F o l d e r " ,   " I s V i r t u a l I t e m " ) \ r                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   " B a s e I t e m s " .                                                                                                                                                                                                                                                                           |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   i d x _ b a s e i t e m s _ t y p e _ i s v i r t u a l i t e m _ t o p p a r e n t i d \ r                                                                                                                                                           + |               1   |         1 . 8 3   |             1 . 8 3   |         1 . 8 3   |               1 . 8 3   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " I s V i r t u a l I t e m " ,   " T o p P a r e n t I d " ) \ r                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   " B a s e I                                                                                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   i d x _ b a s e i t e m s _ d a t e c r e a t e d _ f i l t e r e d \ r                                                                                                                                                                               + |               1   |         1 . 6 6   |             1 . 6 6   |         1 . 6 6   |               1 . 6 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " D a t e C r e a t e d "   D E S C ,   " T y p e " ,   " I s V i r t u a l I t e m " ) \ r                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   " B a s e I t e m s "                                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 1 . " I d " ,   b 1 . " A l b u m " ,   b 1 . " A l b u m A r t i s t s " ,   b 1 . " A r t i s t s " ,   b 1 . " A u d i o " ,   b 1 . " C h a n n e l I d " ,   b 1 . " C l e a n N a m e " ,   b 1 . " C o m m u n i t y R a t i n g " ,   b 1 . " C r i t i c R a t i n g " ,   b 1 . "   |             3 9   |         0 . 5 5   |             1 . 6 3   |         0 . 3 3   |             2 1 . 5 8   |                         3 9   |                             1 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ s e r i e s p r e s e n t a t i o n u n i q u e k e y _ i d x   \ r                                                                                                                                                               + |               1   |         1 . 5 9   |             1 . 5 9   |         1 . 5 9   |               1 . 5 9   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " S e r i e s P r e s e n t a t i o n U n i q u e K e y " ,   " I n d e x N u m b e r " ,   " P a r e n t I n                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ d a t e m o d i f i e d _ i d x   \ r                                                                                                                                                                                             + |               1   |         1 . 5 8   |             1 . 5 8   |         1 . 5 8   |               1 . 5 8   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " D a t e M o d i f i e d "   D E S C )                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   L O C K   T A B L E   p u b l i c . " _ _ E F M i g r a t i o n s H i s t o r y " ,   l i b r a r y . " _ _ E F M i g r a t i o n s H i s t o r y " ,   a c t i v i t y l o g . " A c t i v i t y L o g s " ,   a u t h e n t i c a t i o n . " A p i K e y s " ,   l i b r a r y . " B a s e I t e m s " ,   |             1 1   |         1 . 1 6   |             1 . 5 1   |         0 . 6 2   |             1 2 . 7 8   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ t o p p a r e n t i d _ i d x   \ r                                                                                                                                                                                               + |               1   |         1 . 4 7   |             1 . 4 7   |         1 . 4 7   |               1 . 4 7   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " T o p P a r e n t I d " ,   " T y p e " )                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |         1 6 0 4   |         0 . 1 1   |             1 . 4 6   |         0 . 0 3   |           1 8 0 . 8 5   |                     4 6 2 5   |                             2 . 8 8   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " P a r e n t I d "   =   $ 1   A N D   ( b . " I s F o l d e r "   O R   b . " I s V i r t u a l I t e m " )                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ p a r e n t i d _ i d x   \ r                                                                                                                                                                                                     + |               1   |         1 . 4 4   |             1 . 4 4   |         1 . 4 4   |               1 . 4 4   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " P a r e n t I d " ,   " T y p e " )                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ d a t e c r e a t e d _ i d x   \ r                                                                                                                                                                                               + |               1   |         1 . 4 0   |             1 . 4 0   |         1 . 4 0   |               1 . 4 0   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " D a t e C r e a t e d "   D E S C )                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ p r e m i e r e d a t e _ i d x   \ r                                                                                                                                                                                             + |               1   |         1 . 3 8   |             1 . 3 8   |         1 . 3 8   |               1 . 3 8   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " P r e m i e r e D a t e "   D E S C )                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ s o r t n a m e _ i d x   \ r                                                                                                                                                                                                     + |               1   |         1 . 3 1   |             1 . 3 1   |         1 . 3 1   |               1 . 3 1   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " S o r t N a m e " )                                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |               5   |         0 . 7 9   |             1 . 2 9   |         0 . 3 2   |               3 . 9 4   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   I F   N O T   E X I S T S   b a s e i t e m s _ p r o d u c t i o n y e a r _ i d x   \ r                                                                                                                                                                                         + |               1   |         1 . 2 7   |             1 . 2 7   |         1 . 2 7   |               1 . 2 7   |                           0   |                             0 . 0 0   |       F A S T 
 
   O N   l i b r a r y . " B a s e I t e m s "   ( " P r o d u c t i o n Y e a r "   D E S C )                                                                                                                                                                                                                   |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |             8 9   |         0 . 2 9   |             1 . 2 6   |         0 . 0 8   |             2 5 . 7 0   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b 1 . " I d " ,   b 1 . " B l u r h a s h " ,   b 1 . " D a t e M o d i f i e d " ,   b 1 . " H e i g h t " ,   b 1 . " I m a g e T y p e " ,   b 1 . " I t e m I d " ,   b 1 . " P a t h " ,   b 1 . " W i d t h " ,   b . " I d "                                                           + |               2   |         0 . 9 7   |             1 . 2 4   |         0 . 7 0   |               1 . 9 4   |                       2 5 1   |                         1 2 5 . 5 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S                                                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ I d _ T y p e _ I s F o l d e r _ I s V i r t u a l I t e m "   O N   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " T y p e " ,   " I s F o l d e r " ,   " I s V i r t u a l I t e m " )                                                     |               1   |         0 . 9 8   |             0 . 9 8   |         0 . 9 8   |               0 . 9 8   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               3   |         0 . 6 8   |             0 . 9 2   |         0 . 4 3   |               2 . 0 5   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               3   |         0 . 7 5   |             0 . 9 1   |         0 . 5 1   |               2 . 2 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ M e d i a T y p e _ T o p P a r e n t I d _ I s V i r t u a l I t e m _ P r e s e n t a t i o n U ~ "   O N   l i b r a r y . " B a s e I t e m s "   ( " M e d i a T y p e " ,   " T o p P a r e n t I d " ,   " I s V i r t u a l I t e m " ,   " P   |               1   |         0 . 9 0   |             0 . 9 0   |         0 . 9 0   |               0 . 9 0   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ I s F o l d e r _ T o p P a r e n t I d _ I s V i r t u a l I t e m _ P r e s e n t a t i o n U n ~ "   O N   l i b r a r y . " B a s e I t e m s "   ( " I s F o l d e r " ,   " T o p P a r e n t I d " ,   " I s V i r t u a l I t e m " ,   " P r   |               1   |         0 . 8 9   |             0 . 8 9   |         0 . 8 9   |               0 . 8 9   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |             4 2   |         0 . 4 7   |             0 . 8 8   |         0 . 1 4   |             1 9 . 8 1   |                         4 2   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ P r e s e n t a t i o n U n i q u e K e y "   O N   l i b r a r y . " B a s e I t e m s "   ( " P r e s e n t a t i o n U n i q u e K e y " )                                                                                                           |               1   |         0 . 8 6   |             0 . 8 6   |         0 . 8 6   |               0 . 8 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T y p e _ T o p P a r e n t I d _ I s V i r t u a l I t e m _ P r e s e n t a t i o n U n i q u e ~ "   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " T o p P a r e n t I d " ,   " I s V i r t u a l I t e m " ,   " P r e s e n   |               1   |         0 . 8 4   |             0 . 8 4   |         0 . 8 4   |               0 . 8 4   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T y p e _ T o p P a r e n t I d _ S t a r t D a t e "   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " T o p P a r e n t I d " ,   " S t a r t D a t e " )                                                                           |               1   |         0 . 7 6   |             0 . 7 6   |         0 . 7 6   |               0 . 7 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ P a r e n t I d "   O N   l i b r a r y . " B a s e I t e m s "   ( " P a r e n t I d " )                                                                                                                                                               |               1   |         0 . 7 3   |             0 . 7 3   |         0 . 7 3   |               0 . 7 3   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b 3 . " I d " ,   b 3 . " A l b u m " ,   b 3 . " A l b u m A r t i s t s " ,   b 3 . " A r t i s t s " ,   b 3 . " A u d i o " ,   b 3 . " C h a n n e l I d " ,   b 3 . " C l e a n N a m e " ,   b 3 . " C o m m u n i t y R a t i n g " ,   b 3 . " C r i t i c R a t i n g " ,   b 3 . "   |               1   |         0 . 7 3   |             0 . 7 3   |         0 . 7 3   |               0 . 7 3   |                         1 2   |                           1 2 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T y p e _ S e r i e s P r e s e n t a t i o n U n i q u e K e y _ I s F o l d e r _ I s V i r t u ~ "   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " S e r i e s P r e s e n t a t i o n U n i q u e K e y " ,   " I s F o l d e   |               1   |         0 . 7 1   |             0 . 7 1   |         0 . 7 1   |               0 . 7 1   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T y p e _ T o p P a r e n t I d _ P r e s e n t a t i o n U n i q u e K e y "   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " T o p P a r e n t I d " ,   " P r e s e n t a t i o n U n i q u e K e y " )                           |               1   |         0 . 7 1   |             0 . 7 1   |         0 . 7 1   |               0 . 7 1   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T y p e _ T o p P a r e n t I d _ I d "   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " T o p P a r e n t I d " ,   " I d " )                                                                                                       |               1   |         0 . 6 9   |             0 . 6 9   |         0 . 6 9   |               0 . 6 9   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T o p P a r e n t I d _ I d "   O N   l i b r a r y . " B a s e I t e m s "   ( " T o p P a r e n t I d " ,   " I d " )                                                                                                                                 |               1   |         0 . 6 9   |             0 . 6 9   |         0 . 6 9   |               0 . 6 9   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ T y p e _ S e r i e s P r e s e n t a t i o n U n i q u e K e y _ P r e s e n t a t i o n U n i q ~ "   O N   l i b r a r y . " B a s e I t e m s "   ( " T y p e " ,   " S e r i e s P r e s e n t a t i o n U n i q u e K e y " ,   " P r e s e n t   |               1   |         0 . 6 8   |             0 . 6 8   |         0 . 6 8   |               0 . 6 8   |                           0   |                             0 . 0 0   |       F A S T 
 
   C R E A T E   I N D E X   " I X _ B a s e I t e m s _ P a t h "   O N   l i b r a r y . " B a s e I t e m s "   ( " P a t h " )                                                                                                                                                                               |               1   |         0 . 6 7   |             0 . 6 7   |         0 . 6 7   |               0 . 6 7   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   b 4 . " I d " ,   b 4 . " A l b u m " ,   b 4 . " A l b u m A r t i s t s " ,   b 4 . " A r t i s t s " ,   b 4 . " A u d i o " ,   b 4 . " C h a n n e l I d " ,   b 4 . " C l e a n N a m e " ,   b 4 . " C o m m u n i t y R a t i n g " ,   b 4 . " C r i t i c R a t i n g " ,   b 4 . "   |               2   |         0 . 4 7   |             0 . 5 2   |         0 . 4 2   |               0 . 9 5   |                           1   |                             0 . 5 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               1   |         0 . 4 6   |             0 . 4 6   |         0 . 4 6   |               0 . 4 6   |                           1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "   I N   (                                                                                                                                                                                                                                                                           + |                   |                   |                       |                   |                         |                               |                                       |   
 
           S E L E C T   (                                                                                                                                                                                                                                                                                     + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   S E L E C T   b 1 . " I d "                                                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b 1                                                                                                                                                                                                                                 + |                   |                   |                       |                   |                         |                               |                                       |   
 
                                                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   I N S E R T   I N T O   l i b r a r y . " B a s e I t e m s "   ( " I d " ,   " A l b u m " ,   " A l b u m A r t i s t s " ,   " A r t i s t s " ,   " A u d i o " ,   " C h a n n e l I d " ,   " C l e a n N a m e " ,   " C o m m u n i t y R a t i n g " ,   " C r i t i c R a t i n g " ,   " C u s t   |               1   |         0 . 3 9   |             0 . 3 9   |         0 . 3 9   |               0 . 3 9   |                           1   |                             1 . 0 0   |       F A S T 
 
   S E L E C T   b 2 . " I d " ,   b 2 . " A l b u m " ,   b 2 . " A l b u m A r t i s t s " ,   b 2 . " A r t i s t s " ,   b 2 . " A u d i o " ,   b 2 . " C h a n n e l I d " ,   b 2 . " C l e a n N a m e " ,   b 2 . " C o m m u n i t y R a t i n g " ,   b 2 . " C r i t i c R a t i n g " ,   b 2 . "   |             2 5   |         0 . 1 6   |             0 . 3 1   |         0 . 0 7   |               4 . 0 2   |                           0   |                             0 . 0 0   |       F A S T 
 
   U P D A T E   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                               + |               1   |         0 . 2 7   |             0 . 2 7   |         0 . 2 7   |               0 . 2 7   |                           1   |                             1 . 0 0   |       F A S T 
 
   S E T   " I n h e r i t e d P a r e n t a l R a t i n g V a l u e "   =   $ 1                                                                                                                                                                                                                               + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " O f f i c i a l R a t i n g "   I S   N U L L   O R   b . " O f f i c i a l R a t i n g "   =   $ 2                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               2   |         0 . 2 6   |             0 . 2 6   |         0 . 2 5   |               0 . 5 1   |                           4   |                             2 . 0 0   |       F A S T 
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |           3 3 7   |         0 . 0 5   |             0 . 2 5   |         0 . 0 2   |             1 7 . 8 3   |                       1 3 0   |                             0 . 3 9   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " P a r e n t I d "   =   $ 1                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d "                                                                                                                                                                                                                                                                                   + |               2   |         0 . 1 5   |             0 . 1 9   |         0 . 1 1   |               0 . 3 0   |                         2 3   |                           1 1 . 5 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " P a r e n t I d "   I N   ( $ 1   / * ,   . . .   * / )                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   U P D A T E   l i b r a r y . " B a s e I t e m s "   S E T   " C l e a n N a m e "   =   $ 1                                                                                                                                                                                                               + |               1   |         0 . 1 5   |             0 . 1 5   |         0 . 1 5   |               0 . 1 5   |                           1   |                             1 . 0 0   |       F A S T 
 
   W H E R E   " I d "   =   $ 2                                                                                                                                                                                                                                                                                 |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |               1   |         0 . 1 1   |             0 . 1 1   |         0 . 1 1   |               0 . 1 1   |                           1   |                             1 . 0 0   |       F A S T 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               1   |         0 . 0 9   |             0 . 0 9   |         0 . 0 9   |               0 . 0 9   |                           0   |                             0 . 0 0   |       F A S T 
 
   U P D A T E   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                               + |               1   |         0 . 0 8   |             0 . 0 8   |         0 . 0 8   |               0 . 0 8   |                           1   |                             1 . 0 0   |       F A S T 
 
   S E T   " I n h e r i t e d P a r e n t a l R a t i n g S u b V a l u e "   =   $ 1                                                                                                                                                                                                                         + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " O f f i c i a l R a t i n g "   I S   N U L L   O R   b . " O f f i c i a l R a t i n g "   =   $ 2                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a m e " ,   b 0 . " C o m m u n i t y R a t i n g " ,   b 0 . " C r i t i c R a t i n g " ,   b 0 . "   |               2   |         0 . 0 6   |             0 . 0 7   |         0 . 0 5   |               0 . 1 2   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               1   |         0 . 0 5   |             0 . 0 5   |         0 . 0 5   |               0 . 0 5   |                           1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " N a m e "   I S   N O T   N U L L   A N D   b . " N a m e "   < >   $ 1                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |               1   |         0 . 0 5   |             0 . 0 5   |         0 . 0 5   |               0 . 0 5   |                           1   |                             1 . 0 0   |       F A S T 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " I t e m I d " ,   b . " I d "                                                                                                                                                                                                                                       + |               2   |         0 . 0 4   |             0 . 0 4   |         0 . 0 3   |               0 . 0 7   |                           0   |                             0 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   I N N E R   J O I N   l i b r a r y . " B a s e I t e m T r a i l e r T y p e s "   A S   b 0   O N   b . " I d "   =   b 0 . " I t e m I d "                                                                                                                                                               + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " I d "                                                                                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " P a t h "                                                                                                                                                                                                                                                               + |               2   |         0 . 0 3   |             0 . 0 4   |         0 . 0 2   |               0 . 0 6   |                           0   |                             0 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " M e d i a T y p e "   =   $ 3   A N D   N O T   ( b . " I s V i r t u a l I t e m " )   A N D   N O T   ( b . " I s F o l d e r " )                                                                                                                                                       + |                   |                   |                       |                   |                         |                               |                                       |   
 
   O R D E R   B Y   b . " I d "                                                                                                                                                                                                                                                                               + |                   |                   |                       |                   |                         |                               |                                       |   
 
   L I M I                                                                                                                                                                                                                                                                                                       |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b . " C o m m u n i t y R a t i n g " ,   b . " C r i t i c R a t i n g " ,   b . " C u s t o m R a t i   |               1   |         0 . 0 3   |             0 . 0 3   |         0 . 0 3   |               0 . 0 3   |                           0   |                             0 . 0 0   |       F A S T 
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               1   |         0 . 0 3   |             0 . 0 3   |         0 . 0 3   |               0 . 0 3   |                           1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " T y p e "   =   A N Y   ( $ 1 )                                                                                                                                                                                                                                                             |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               2   |         0 . 0 3   |             0 . 0 3   |         0 . 0 3   |               0 . 0 6   |                           2   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " M e d i a T y p e "   =   $ 1   A N D   N O T   ( b . " I s V i r t u a l I t e m " )   A N D   N O T   ( b . " I s F o l d e r " )                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   D I S T I N C T   b . " O f f i c i a l R a t i n g "                                                                                                                                                                                                                                         + |               1   |         0 . 0 3   |             0 . 0 3   |         0 . 0 3   |               0 . 0 3   |                           1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               1   |         0 . 0 3   |             0 . 0 3   |         0 . 0 3   |               0 . 0 3   |                           1   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                   + |                   |                   |                       |                   |                         |                               |                                       |   
 
   W H E R E   b . " T y p e "   =   $ 1                                                                                                                                                                                                                                                                         |                   |                   |                       |                   |                         |                               |                                       |   
 
   S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                                                                                                                                     + |               2   |         0 . 0 3   |             0 . 0 3   |         0 . 0 2   |               0 . 0 5   |                           2   |                             1 . 0 0   |       F A S T 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                                                                                                                                     |                   |                   |                       |                   |                         |                               |                                       |   
 
 ( 1 7 8   r o w s ) 
 
 
 
 T i m e :   7 0 . 7 7 4   m s 
 
 
 
 6 .   P E O P L E S   A N D   I T E M V A L U E S   Q U E R I E S 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 Q u e r i e s   o n   h i g h - s e q u e n t i a l - s c a n   t a b l e s 
 
 
 
   t a b l e _ n a m e   |                                                                                         q u e r y _ p r e v i e w                                                                                           |     c a l l s     |   a v g _ m s     |     m a x _ m s     |     t o t a l _ m s     |   r o w s _ r e t u r n e d   
 
 - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - 
 
   P e o p l e s         |   S E L E C T   p . " I d " ,   p . " N a m e " ,   p . " P e r s o n T y p e "                                                                                                                           + |     2 1 1 8 2 5   |         1 . 1 6   |   1 2 0 9 4 . 9 5   |     2 4 6 7 5 6 . 2 4   |               1 7 7 3 8 1 4 
 
                         |   F R O M   l i b r a r y . " P e o p l e s "   A S   p                                                                                                                                                   + |                   |                   |                     |                         |   
 
                         |   W H E R E   E X I S T S   (                                                                                                                                                                             + |                   |                   |                     |                         |   
 
                         |           S E L E C T   $ 3                                                                                                                                                                               + |                   |                   |                     |                         |   
 
                         |                                                                                                                                                                                                             |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |           1 3 6   |     4 7 6 . 0 8   |     5 4 5 7 . 7 0   |       6 4 7 4 7 . 3 9   |                   4 0 0 4 0 
 
   I t e m V a l u e s   |   I N S E R T   I N T O   l i b r a r y . " I t e m V a l u e s M a p "   ( " I t e m I d " ,   " I t e m V a l u e I d " )                                                                               + |   1 2 3 5 7 8 9   |         0 . 6 4   |     5 3 3 3 . 1 2   |     7 9 0 2 1 1 . 4 2   |               1 2 3 5 7 8 9 
 
                         |   V A L U E S   ( $ 1 ,   $ 2 )                                                                                                                                                                             |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   D E L E T E   F R O M   l i b r a r y . " I t e m V a l u e s "   A S   i                                                                                                                               + |           2 4 7   |     2 0 8 . 3 1   |     3 8 3 5 . 1 6   |       5 1 4 5 2 . 5 0   |                     7 8 6 1 
 
                         |   W H E R E   (                                                                                                                                                                                           + |                   |                   |                     |                         |   
 
                         |           S E L E C T   c o u n t ( * ) : : i n t                                                                                                                                                         + |                   |                   |                     |                         |   
 
                         |           F R O M   l i b r a r y . " I t e m V a l u e s M                                                                                                                                                 |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   C O P Y   l i b r a r y . " I t e m V a l u e s M a p "   ( " I t e m I d " ,   " I t e m V a l u e I d " )   T O   s t d o u t                                                                           |               9   |     8 5 5 . 1 0   |     2 5 9 2 . 4 5   |         7 6 9 5 . 9 4   |               2 8 4 2 2 2 4 
 
   I t e m V a l u e s   |   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |             6 7   |     5 9 6 . 0 8   |     2 5 2 9 . 1 9   |       3 9 9 3 7 . 5 0   |                     8 9 3 5 
 
   I t e m V a l u e s   |   S E L E C T   b . " I d "                                                                                                                                                                               + |             2 3   |     4 0 0 . 2 1   |     1 4 9 1 . 9 3   |         9 2 0 4 . 9 1   |                       4 0 6 
 
                         |   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |                   |                   |                     |                         |   
 
                         |   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |                   |                   |                     |                         |   
 
                         |           S E L E C T   (                                                                                                                                                                                 + |                   |                   |                     |                         |   
 
                         |                   S E L E C T   b 1 . " I d "                                                                                                                                                             + |                   |                   |                     |                         |   
 
                         |                                                                                                                                                                                                             |                   |                   |                     |                         |   
 
   P e o p l e s         |   S E L E C T   p 3 . " I t e m I d " ,   p 3 . " P e o p l e I d " ,   p 3 . " R o l e " ,   p 3 . " L i s t O r d e r " ,   p 3 . " S o r t O r d e r " ,   p . " I d "                                 + |     1 6 9 7 0 2   |         0 . 4 2   |     1 3 5 1 . 3 8   |       7 1 0 7 8 . 8 4   |               1 7 7 3 8 1 4 
 
                         |   F R O M   l i b r a r y . " P                                                                                                                                                                             |                   |                   |                     |                         |   
 
   P e o p l e s         |   C R E A T E   I N D E X   C O N C U R R E N T L Y   I F   N O T   E X I S T S   i d x _ p e o p l e s _ n a m e _ l o w e r                                                                             + |               1   |   1 3 2 8 . 3 1   |     1 3 2 8 . 3 1   |         1 3 2 8 . 3 1   |                           0 
 
                         |   O N   l i b r a r y . " P e o p l e s "   ( L O W E R ( " N a m e " ) )                                                                                                                                 + |                   |                   |                     |                         |   
 
                         |                                                                                                                                                                                                             |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   S E L E C T   (                                                                                                                                                                                         + |               3   |     7 1 7 . 0 8   |     1 2 0 4 . 7 5   |         2 1 5 1 . 2 3   |                       1 3 8 
 
                         |           S E L E C T   i 5 . " V a l u e "                                                                                                                                                               + |                   |                   |                     |                         |   
 
                         |           F R O M   l i b r a r y . " I t e m V a l u e s M a p "   A S   i 2                                                                                                                             + |                   |                   |                     |                         |   
 
                         |           I N N E R   J O I N   l i b r a r y . " I t e m V a                                                                                                                                               |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   D E L E T E   F R O M   l i b r a r y . " I t e m V a l u e s M a p "   A S   i                                                                                                                         + |               3   |     9 0 0 . 4 4   |       9 3 4 . 7 2   |         2 7 0 1 . 3 1   |                 8 2 0 5 6 6 
 
                         |   U S I N G   l i b r a r y . " I t e m V a l u e s "   A S   i 0                                                                                                                                         + |                   |                   |                     |                         |   
 
                         |   W H E R E   i . " I t e m V a l u e I d "   =   i 0                                                                                                                                                       |                   |                   |                     |                         |   
 
   P e o p l e s         |   S E L E C T   p . " I t e m I d " ,   p . " P e o p l e I d " ,   p . " R o l e " ,   p . " L i s t O r d e r " ,   p . " S o r t O r d e r " ,   p 0 . " I d " ,   p 0 . " N a m e " ,   p 0 . " P e r   |     1 4 4 0 5 5   |         0 . 1 9   |       7 4 5 . 0 3   |       2 7 3 3 6 . 8 3   |                 7 6 9 8 1 4 
 
   I t e m V a l u e s   |   S E L E C T   b 1 . " I d "                                                                                                                                                                             + |           1 7 0   |       3 0 . 9 2   |       7 1 9 . 1 7   |         5 2 5 6 . 1 3   |                       3 5 9 
 
                         |   F R O M   (                                                                                                                                                                                             + |                   |                   |                     |                         |   
 
                         |           S E L E C T   D I S T I N C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o                                               |                   |                   |                     |                         |   
 
   P e o p l e s         |   I N S E R T   I N T O   l i b r a r y . " P e o p l e s "   ( " I d " ,   " N a m e " ,   " P e r s o n T y p e " )                                                                                     + |     1 0 6 4 9 2   |         0 . 1 4   |       6 9 9 . 6 6   |       1 4 6 3 6 . 5 1   |                 1 0 6 4 9 2 
 
                         |   V A L U E S   ( $ 1 ,   $ 2 ,   $ 3 )                                                                                                                                                                     |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   S E L E C T   (                                                                                                                                                                                         + |               3   |     4 0 1 . 2 3   |       6 3 5 . 3 2   |         1 2 0 3 . 6 8   |                         4 0 
 
                         |           S E L E C T   i 5 . " V a l u e "                                                                                                                                                               + |                   |                   |                     |                         |   
 
                         |           F R O M   l i b r a r y . " I t e m V a l u e s M a p "   A S   i 2                                                                                                                             + |                   |                   |                     |                         |   
 
                         |           I N N E R   J O I N   l i b r a r y . " I t e m V a                                                                                                                                               |                   |                   |                     |                         |   
 
   P e o p l e s         |   A N A L Y Z E   V E R B O S E   l i b r a r y . " P e o p l e s "                                                                                                                                         |               1   |     5 8 1 . 4 6   |       5 8 1 . 4 6   |           5 8 1 . 4 6   |                           0 
 
   P e o p l e s         |   C O P Y   l i b r a r y . " P e o p l e s "   ( " I d " ,   " N a m e " ,   " P e r s o n T y p e " )   T O   s t d o u t                                                                                 |               9   |     2 2 3 . 8 2   |       5 2 3 . 3 7   |         2 0 1 4 . 3 6   |                 8 6 7 3 1 7 
 
   P e o p l e s         |   S E L E C T   p . " I d " ,   p . " N a m e " ,   p . " P e r s o n T y p e "                                                                                                                           + |     1 4 4 0 5 5   |       5 4 . 7 9   |       4 9 2 . 4 3   |   7 8 9 3 0 9 7 . 6 5   |               1 0 1 4 4 1 2 
 
                         |   F R O M   l i b r a r y . " P e o p l e s "   A S   p                                                                                                                                                   + |                   |                   |                     |                         |   
 
                         |   W H E R E   p . " N a m e "   | |   $ 2   | |   C O A L E S C E                                                                                                                                           |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   S E L E C T   b . " I d "                                                                                                                                                                               + |             1 8   |     3 1 4 . 7 4   |       4 8 6 . 0 3   |         5 6 6 5 . 2 4   |                       2 5 6 
 
                         |   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |                   |                   |                     |                         |   
 
                         |   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |                   |                   |                     |                         |   
 
                         |           S E L E C T   (                                                                                                                                                                                 + |                   |                   |                     |                         |   
 
                         |                   S E L E C T   b 1 . " I d "                                                                                                                                                             + |                   |                   |                     |                         |   
 
                         |                                                                                                                                                                                                             |                   |                   |                     |                         |   
 
   I t e m V a l u e s   |   S E L E C T   b . " I d "                                                                                                                                                                               + |               2   |     4 4 3 . 3 8   |       4 4 4 . 0 0   |           8 8 6 . 7 7   |                         3 2 
 
                         |   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |                   |                   |                     |                         |   
 
                         |   W H E R E   b . " I d "   I N   (                                                                                                                                                                       + |                   |                   |                     |                         |   
 
                         |           S E L E C T   (                                                                                                                                                                                 + |                   |                   |                     |                         |   
 
                         |                   S E L E C T   b 1 . " I d "                                                                                                                                                             + |                   |                   |                     |                         |   
 
                         |                                                                                                                                                                                                             |                   |                   |                     |                         |   
 
 ( 2 0   r o w s ) 
 
 
 
 T i m e :   6 4 . 4 3 9   m s 
 
 
 
 7 .   E F F I C I E N T   Q U E R I E S   ( M a n y   r o w s ,   f a s t   e x e c u t i o n ) 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 T h e s e   q u e r i e s   r e t u r n   m a n y   r o w s   b u t   e x e c u t e   q u i c k l y   ( g o o d   i n d e x e s ! ) 
 
 
 
                                                                                         q u e r y _ p r e v i e w                                                                                           |     c a l l s     |   a v g _ m s   |   t o t a l _ r o w s _ r e t u r n e d   |   a v g _ r o w s _ p e r _ c a l l   |   m s _ p e r _ r o w   
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a   |       7 9 5 7 1   |       9 . 2 1   |                         1 0 1 9 0 4 6 9   |                         1 2 8 . 0 7   |           0 . 0 7 1 9 
 
   S E L E C T   b 4 . " I d " ,   b 4 . " A l b u m " ,   b 4 . " A l b u m A r t i s t s " ,   b 4 . " A r t i s t s " ,   b 4 . " A u d i o " ,   b 4 . " C h a n n e l I d " ,   b 4 . " C l e a n N a   |   2 8 8 9 7 4 9   |       0 . 3 1   |                           5 6 8 1 9 8 6   |                             1 . 9 7   |           0 . 1 5 8 7 
 
   S E L E C T   b 0 . " I d " ,   b 0 . " A l b u m " ,   b 0 . " A l b u m A r t i s t s " ,   b 0 . " A r t i s t s " ,   b 0 . " A u d i o " ,   b 0 . " C h a n n e l I d " ,   b 0 . " C l e a n N a   |         7 1 7 8   |     4 7 . 9 6   |                           4 5 1 6 1 1 3   |                         6 2 9 . 1 6   |           0 . 0 7 6 2 
 
   S E L E C T   i . " I t e m V a l u e I d " ,   i . " C l e a n V a l u e " ,   i . " T y p e " ,   i . " V a l u e "                                                                                   + |     5 0 4 9 4 7   |       4 . 6 0   |                           2 9 9 4 7 1 8   |                             5 . 9 3   |           0 . 7 7 5 2 
 
   F R O M   l i b r a r y . " I t e m V a l u e s "   A S   i                                                                                                                                             + |                   |                 |                                           |                                       |   
 
   W H E R E   i . "                                                                                                                                                                                         |                   |                 |                                           |                                       |   
 
   S E L E C T   b . " I d " ,   b . " A l b u m " ,   b . " A l b u m A r t i s t s " ,   b . " A r t i s t s " ,   b . " A u d i o " ,   b . " C h a n n e l I d " ,   b . " C l e a n N a m e " ,   b .   |         3 8 0 1   |     3 7 . 5 1   |                           2 0 5 3 2 3 6   |                         5 4 0 . 1 8   |           0 . 0 6 9 4 
 
   S E L E C T   b . " I d "                                                                                                                                                                               + |     7 9 9 0 6 9   |       0 . 0 7   |                           1 8 3 1 9 6 4   |                             2 . 2 9   |           0 . 0 3 0 4 
 
   F R O M   l i b r a r y . " B a s e I t e m s "   A S   b                                                                                                                                               + |                   |                 |                                           |                                       |   
 
   W H E R E   b . " I d "   =   A N Y   ( $ 1 )                                                                                                                                                             |                   |                 |                                           |                                       |   
 
   S E L E C T   i . " I t e m V a l u e I d " ,   i . " I t e m I d "                                                                                                                                     + |     5 0 4 9 4 5   |       0 . 1 0   |                           1 7 7 7 8 4 0   |                             3 . 5 2   |           0 . 0 2 9 4 
 
   F R O M   l i b r a r y . " I t e m V a l u e s M a p "   A S   i                                                                                                                                       + |                   |                 |                                           |                                       |   
 
   W H E R E   i . " I t e m I d "   =   A N Y   ( $ 1 )                                                                                                                                                     |                   |                 |                                           |                                       |   
 
   S E L E C T   p 3 . " I t e m I d " ,   p 3 . " P e o p l e I d " ,   p 3 . " R o l e " ,   p 3 . " L i s t O r d e r " ,   p 3 . " S o r t O r d e r " ,   p . " I d "                                 + |     1 6 9 7 0 2   |       0 . 4 2   |                           1 7 7 3 8 1 4   |                           1 0 . 4 5   |           0 . 0 4 0 1 
 
   F R O M   l i b r a r y . " P                                                                                                                                                                             |                   |                 |                                           |                                       |   
 
   S E L E C T   p . " I d " ,   p . " N a m e " ,   p . " P e r s o n T y p e "                                                                                                                           + |     2 1 1 8 2 5   |       1 . 1 6   |                           1 7 7 3 8 1 4   |                             8 . 3 7   |           0 . 1 3 9 1 
 
   F R O M   l i b r a r y . " P e o p l e s "   A S   p                                                                                                                                                   + |                   |                 |                                           |                                       |   
 
   W H E R E   E X I S T S   (                                                                                                                                                                             + |                   |                 |                                           |                                       |   
 
           S E L E C T   $ 3                                                                                                                                                                               + |                   |                 |                                           |                                       |   
 
                                                                                                                                                                                                             |                   |                 |                                           |                                       |   
 
   S E L E C T   a . " I t e m I d " ,   a . " P a r e n t I t e m I d "                                                                                                                                   + |     2 9 4 1 1 2   |       0 . 0 9   |                           1 2 4 4 5 3 6   |                             4 . 2 3   |           0 . 0 2 1 6 
 
   F R O M   l i b r a r y . " A n c e s t o r I d s "   A S   a                                                                                                                                           + |                   |                 |                                           |                                       |   
 
   W H E R E   a . " I t e m I d "   =   $ 1                                                                                                                                                                 |                   |                 |                                           |                                       |   
 
 ( 1 0   r o w s ) 
 
 
 
 T i m e :   2 9 . 4 8 3   m s 
 
 
 
 8 .   C U R R E N T L Y   R U N N I N G   Q U E R I E S 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
   p i d   |   u s e n a m e   |   a p p l i c a t i o n _ n a m e   |   d u r a t i o n   |   s t a t e   |   w a i t _ e v e n t _ t y p e   |   w a i t _ e v e n t   |   q u e r y _ p r e v i e w   
 
 - - - - - + - - - - - - - - - + - - - - - - - - - - - - - - - - - - + - - - - - - - - - - + - - - - - - - + - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - 
 
 ( 0   r o w s ) 
 
 
 
 T i m e :   7 . 2 2 3   m s 
 
 
 
 9 .   O V E R A L L   Q U E R Y   S T A T I S T I C S   S U M M A R Y 
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
   t o t a l _ u n i q u e _ q u e r i e s   |   t o t a l _ c a l l s   |   t o t a l _ e x e c _ m i n u t e s   |   a v g _ q u e r y _ t i m e _ m s   |   s l o w e s t _ q u e r y _ e v e r _ m s   |   s l o w e s t _ q u e r y _ e v e r _ s e c o n d s   |   t o t a l _ r o w s _ r e t u r n e d   |   a v g _ r o w s _ p e r _ q u e r y   
 
 - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - 
 
                                     5 7 6   |         2 2 9 5 3 3 0 1   |                           3 7 3 . 3 6   |                         1 9 5 . 3 3   |                           1 1 0 0 4 8 . 0 0   |                                           1 1 0 . 0 5   |                         8 3 7 9 8 4 8 8   |                         5 3 1 5 . 9 2 
 
 ( 1   r o w ) 
 
 
 
 T i m e :   3 9 . 3 7 6   m s 
 
 
 
 
 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 R E C O M M E N D A T I O N S 
 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 
 
 B a s e d   o n   t h e   a n a l y s i s   a b o v e : 
 
 
 
 1 .   C R I T I C A L   Q U E R I E S   ( > 1 0 0 s ) : 
 
       -   R e v i e w   q u e r i e s   m a r k e d   a"    C R I T I C A L 
 
       -   C h e c k   E X P L A I N   A N A L Y Z E   f o r   t h e s e   q u e r i e s 
 
       -   C o n s i d e r   q u e r y   r e w r i t e   o r   a d d i t i o n a l   i n d e x e s 
 
 
 
 2 .   S L O W   Q U E R I E S   ( > 1 0 s ) : 
 
       -   R e v i e w   q u e r i e s   m a r k e d     )"U%   S L O W 
 
       -   C h e c k   i f   i n d e x e s   a r e   b e i n g   u s e d 
 
       -   R u n :   E X P L A I N   ( A N A L Y Z E ,   B U F F E R S )   < q u e r y > 
 
 
 
 3 .   H I G H   T O T A L   T I M E   Q U E R I E S : 
 
       -   E v e n   f a s t   q u e r i e s   w i t h   m a n y   c a l l s   a d d   u p 
 
       -   C o n s i d e r   c a c h i n g   f r e q u e n t l y   c a l l e d   q u e r i e s 
 
       -   O p t i m i z e   c o n n e c t i o n   p o o l i n g 
 
 
 
 4 .   T O   R E S E T   S T A T I S T I C S : 
 
       R u n :   S E L E C T   p g _ s t a t _ s t a t e m e n t s _ r e s e t ( ) ; 
 
       ( U s e f u l   a f t e r   m a k i n g   o p t i m i z a t i o n   c h a n g e s ) 
 
 
 
 5 .   T O   G E T   F U L L   Q U E R Y   T E X T : 
 
       T h i s   s c r i p t   s h o w s   o n l y   f i r s t   1 0 0 - 1 5 0   c h a r a c t e r s 
 
       Q u e r y   f u l l   t e x t   f r o m   p g _ s t a t _ s t a t e m e n t s   t a b l e   d i r e c t l y 
 
 
 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 