question

Joseph7955 avatar image
Joseph7955 asked

avoiding the use of SELECT * FROM information_schema

Hello i want to to improve the performance of this query by adding a cache for this query or look for a way to optimize it by avoiding the use of SELECT * FROM information_schema.

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'

Can someone help me please

sqlquerydatabaseinformation_schemacache
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.