VIEW vs TABLE querying. What is faster?

You may have asked yourself will VIEW affect performance while querying from it if compared with querying directly from the table. Some people think VIEW may slow down a little bit the query, but it is not true. Let’s create a view to verify it.

Now let’s query it.

Execution time was 0.002 seconds.

Now, let’s try to execute similar query directly from the table.

As we can see it has demonstrated the same execution time basically.

So, the answer is NO. View won’t slow down execution performance. There is no reason for the second query to be quicker since View add nothing to SQL performance


Leave a comment

Your email address will not be published. Required fields are marked *