September 12, 2013 at 10:52 am
A Table and View having same structure and amount of data
40 Columns and 1.5 Million Data...
This data has to be fetched by a BI Tool Which will give better performance...
September 13, 2013 at 1:11 am
Are you asking which will be faster: the view or the table?
A view is basically just a stored SELECT statement on one or more tables.
To get the data out of a table, you need to write a SELECT statement. If it turns out that both SELECT statements are the same, there will be no performance difference.
The only difference is that when you use a view in your BI tool, you hide the complexity. All you see in the tool is SELECT columns FROM myView, instead of perhaps complex SQL statement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply