Q1)Please tel me the impact of number of cols in a table with index and with out index.
The number of columns does not matter that much; rather it is the total row size.
I'm not sure how you could define your tables to speed up your reports - what data that is in the table is rather due to business requirements, and if the business requirements calls for a lot of columns, well it does.
Q2) not only this i also noticed that queries which are fast they become slow after clearing buffer, so i am trying them
Reading from disk is a lot slower than reading from memory.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment