Breaking News: Grepper is joining You.com. Read the official announcement!

sql analyse

Add Answer

Nice Narwhal answered on October 9, 2023 Popularity 4/10 Helpfulness 1/10

answer sql analyse

related sql analyse

related sql explain analyse

sql analyse

Comment

ANALYZE [ VERBOSE ] [ nom_table [ (nom_colonne [, ...] ) ] ]

Popularity 4/10 Helpfulness 1/10 Language sql

Source: docs.postgresql.fr

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 09 2023

Nice Narwhal

0 Answers Avg Quality 2/10

Closely Related Answers

sql analyse

Comment

ANALYZE SELECT * FROM tbl1 
WHERE key1 
  BETWEEN 10 AND 200 AND 
  col1 LIKE 'foo%'\G

*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: tbl1
         type: range
possible_keys: key1
          key: key1
      key_len: 5
          ref: NULL
         rows: 181
       r_rows: 181
     filtered: 100.00
   r_filtered: 10.50
        Extra: Using index condition; Using where

Popularity 3/10 Helpfulness 2/10 Language sql

Source: mariadb.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 10 2023

Nice Narwhal

0 Answers Avg Quality 2/10

sql explain analyse

Comment

EXPLAIN ANALYZE
SELECT first_name, last_name, SUM(amount) AS total
FROM staff INNER JOIN payment
  ON staff.staff_id = payment.staff_id
     AND
     payment_date LIKE '2005-08%'
GROUP BY first_name, last_name;
 
-> Table scan on <temporary>  (actual time=0.001..0.001 rows=2 loops=1)
    -> Aggregate using temporary table  (actual time=58.104..58.104 rows=2 loops=1)
        -> Nested loop inner join  (cost=1757.30 rows=1787) (actual time=0.816..46.135 rows=5687 loops=1)
            -> Table scan on staff  (cost=3.20 rows=2) (actual time=0.047..0.051 rows=2 loops=1)
            -> Filter: (payment.payment_date like '2005-08%')  (cost=117.43 rows=894) (actual time=0.464..22.767 rows=2844 loops=2)
                -> Index lookup on payment using idx_fk_staff_id (staff_id=staff.staff_id)  (cost=117.43 rows=8043) (actual time=0.450..19.988 rows=8024 loops=2)

Popularity 3/10 Helpfulness 1/10 Language sql

Source: dev.mysql.com

Tags: sql explain

Link to this answer
Share Copy Link

Contributed on Oct 10 2023

Nice Narwhal

0 Answers Avg Quality 2/10

sql analyse

Contents

More Related Answers

sql analyse

Closely Related Answers

sql analyse

sql explain analyse

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.