Tag - index

IndexData

How to make your application faster in browsing data?

 Problem Statement: How to make your application faster in  browsing data?  Resolution:  step 1:create Indexes Today we will see how  we can[blox img="http://" height="380" nomargin="false" fixed="false"] Contents [/blox] get or browse data faster by adding indexes in database. most of the fields which are used frequently put index key on all that fields. here we will see how to get all the foreign keys from the datbase. get all the keys by executing  below query to create index script SELECT 'CREATE INDEX IX_' + f.name + ' ON [...]