Sfrgttk

Bash script to truncate subject line of incoming email

How do you funnel food off a cutting board?

Is there a lava-breathing lizard creature (that could be worshipped by a cult) in 5e?

How can the probability of a fumble decrease linearly with more dice?

Has Britain negotiated with any other countries outside the EU in preparation for the exit?

Is using an 'empty' metaphor considered bad style?

What makes papers publishable in top-tier journals?

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

Which communication protocol is used in AdLib sound card?

Early credit roll before the end of the film

Does Skippy chunky peanut butter contain trans fat?

Is there a verb that means to inject with poison?

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

Square Root Distance from Integers

Why would space fleets be aligned?

How to make ice magic work from a scientific point of view?

Why is Agricola named as such?

False written accusations not made public - is there law to cover this?

Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?

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

TikZ graph edges not drawn nicely

Do "fields" always combine by addition?

How do I append a character to the end of every line in an excel cell?

What language shall they sing in?

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.

sql-server mysql view

share

asked 1 min ago

Saurabh SinghSaurabh Singh

1011

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.

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.

sql-server mysql view

share

asked 1 min ago

Saurabh SinghSaurabh Singh

1011

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.

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.

sql-server mysql view

share

asked 1 min ago

Saurabh SinghSaurabh Singh

1011

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

asked 1 min ago

Saurabh SinghSaurabh Singh

1011

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

asked 1 min ago

Saurabh SinghSaurabh Singh

1011

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 1 min ago

Saurabh SinghSaurabh Singh

1011

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 1 min ago

Saurabh SinghSaurabh Singh

1011