This page compares the performance of a query (i.e query execution time) run against the tables before and after a view is created
The following query is run against the tables first without a view and then with a view. The performance in terms of query execution time in each case is compared
Query to generate the bill for the customer run against the table :
SELECT a.order_master_ID, a.customer_ID, a.order_date, a.total_amount, b.product_ID, b.product_cost
FROM order_master_c a, order_details_c b
WHERE a.order_master_ID = 11011
AND a.order_master_ID = b.order_details_ID
Query to generate the bill for the customer run against the view :
SELECT order_master_ID, customer_ID, order_date, total_amount, product_ID, product_cost
FROM v_order
WHERE order_master_ID = 11011
The graph shows better query performance i.e. the query processing time is significantly reduced with the use of views