Ygthkb

Is "the fire consumed everything on its way" correct?

Am I a Rude Number?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Limits of a density function

Why did Democrats in the Senate oppose the Born-Alive Abortion Survivors Protection Act (2019 S.130)?

How do you voice extended chords?

How to find the order of a symmetric group S4?

What is a DAG (Graph Theory)?

Is there any risk in sharing info about technologies and products we use with a supplier?

Plausible reason for gold-digging ant

Do authors have to be politically correct in article-writing?

Strange "DuckDuckGo dork" takes me to random website

How do you catch Smeargle in Pokemon Go?

A curious equality of integrals involving the prime counting function?

How does Leonard in "Memento" remember reading and writing?

Removing whitespace between consecutive numbers

Has any human ever had the choice to leave Earth permanently?

Existence of Riemann surface, holomorphic maps

Identify KNO3 and KH2PO4 at home

Why does photorec keep finding files after I have filled the disk free space as root?

Building an exterior wall within an exterior wall for insulation

Saint abbreviation

Explanation of a regular pattern only occuring for prime numbers

Does diversity provide anything that meritocracy does not?

using view (necessary) with where conditions (dynamically)

Window functions cause awful execution plan when called from a view with external parametrized 'where' clauseEasily show rows that are different between two tables or queriesExecution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table?View with fallback (performance/optimization question)Creating a View with results from join of scalar tablesJoining two inline functions, slows considerably when filtering on second functionSSAS cube process time increased after making fact and dimension smallGroup by's in materialized views and query planningPoor SQL Server Performance With Nested “OR” Conditions In LEFT OUTER JOINPerformance issues with groupwise MAX in JOIN clause

0

Suppose we have two tables like A {a1, a2, a3 ...} and B{b1, b2, b3 ...}

We are using a MySQl view like

Select a.a1, b.b1 from A a Left JOIN  B b ON a.a2=b.b2 

Now our requirement is that we have to put "where conditions" dynamically on some columns of A and B, so we have to again join table and putting a where condition (In current code).

Now as joining twice is increasing our query execution time and I am trying to reduce the time.

We can't remove the view as per the security requirement (SQL SECURITY).

Is there a way to handle this scenario, I thought of using functions with "SQL SECURITY" or there are any other alternatives.

mysql view

share

edited 1 min ago

danblack

1,8611213

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012

New contributor

Saurabh Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What MySQL version? What are the indexes on A,B? What does your EXPLAIN {query} show?
  
  – danblack
  1 min ago
  

  
  
  
  

add a comment | 

0

Suppose we have two tables like A {a1, a2, a3 ...} and B{b1, b2, b3 ...}

We are using a MySQl view like

Select a.a1, b.b1 from A a Left JOIN  B b ON a.a2=b.b2 

Now our requirement is that we have to put "where conditions" dynamically on some columns of A and B, so we have to again join table and putting a where condition (In current code).

Now as joining twice is increasing our query execution time and I am trying to reduce the time.

We can't remove the view as per the security requirement (SQL SECURITY).

Is there a way to handle this scenario, I thought of using functions with "SQL SECURITY" or there are any other alternatives.

mysql view

share

edited 1 min ago

danblack

1,8611213

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012

New contributor

Saurabh Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What MySQL version? What are the indexes on A,B? What does your EXPLAIN {query} show?
  
  – danblack
  1 min ago
  

  
  
  
  

add a comment | 

Suppose we have two tables like A {a1, a2, a3 ...} and B{b1, b2, b3 ...}

We are using a MySQl view like

Select a.a1, b.b1 from A a Left JOIN  B b ON a.a2=b.b2 

Now our requirement is that we have to put "where conditions" dynamically on some columns of A and B, so we have to again join table and putting a where condition (In current code).

Now as joining twice is increasing our query execution time and I am trying to reduce the time.

We can't remove the view as per the security requirement (SQL SECURITY).

Is there a way to handle this scenario, I thought of using functions with "SQL SECURITY" or there are any other alternatives.

mysql view

share

edited 1 min ago

danblack

1,8611213

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012

New contributor

Saurabh Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Select a.a1, b.b1 from A a Left JOIN  B b ON a.a2=b.b2 

share

edited 1 min ago

danblack

1,8611213

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012

New contributor

Saurabh Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

edited 1 min ago

danblack

1,8611213

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012

New contributor

Saurabh Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 1 min ago

danblack

1,8611213

edited 1 min ago

danblack

1,8611213

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012

New contributor

Saurabh Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Saurabh SinghSaurabh Singh

1012