0 Replies - 432 Views - Last Post: 19 September 2018 - 03:18 PM Rate Topic: -----

#1 joseph7955   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 19-September 18

Avoiding the use of SELECT * from information_schema

Posted 19 September 2018 - 03:18 PM

hello can someone help me to add a cache for this query or for a way to optimize it by avoiding the use of SELECT * FROM information_schema to improve the performance of this query

SELECT * FROM   information_schema.key_column_usage AS kcu
       INNER JOIN information_schema.referential_constraints AS rc
               ON ( kcu.constraint_name = rc.constraint_name
                    AND kcu.constraint_schema = rc.constraint_schema )
WHERE  kcu.table_schema = 'joseph79_tiny'
       AND kcu.table_name = 'options'
       AND rc.table_name = 'options'  

SELECT * FROM       information_schema.key_column_usage        AS kcu
INNER JOIN information_schema.referential_constraints AS rc
ON         (
                      kcu.constraint_name = rc.constraint_name
           AND        kcu.constraint_schema = rc.constraint_schema ) wh ere kcu.table_schema = 'joseph79_tiny'
AND        kcu.table_name = 'links'
AND        rc.table_name = 'links'


thank you

Is This A Good Question/Topic? 0
  • +

Page 1 of 1