A database structure that can improve the speed of queries at the cost of disk space and slower inserts/updates. It stores a copy of one or more columns but structures the data differently to allow for faster access.

learn more… | top users | synonyms (2)

-1
votes
1answer
614 views

Will the indexing affect insert/update/delete operation in Mysql [closed]

Will the indexing affect insert/update/delete operation in Mysql 5.1 Will it take down performance of insert update delete operations, If yes, why it will happen so. So are indexes always meant for ...
-2
votes
1answer
4k views

What are performance benefits when using number type instead of using char/varchar?

From various posts, I have summarized about using number type instead of char/varchar for PK: If you choose char/varchar type for PK and your values are short (just some alpha numberic codes) then it ...
-2
votes
2answers
72 views

Index is not used with same Query on two Servers [closed]

I have two notebooks with same specs (same model, only ram is 24GB/32GB, same ssd) and exact same database and same sql server version. SQLIO is 3300 and 3600. Now I run a query on one notebook and ...
-7
votes
1answer
127 views

What is the structure that SQL Server uses to build and maintain indexes called?

What is the structure that SQL Server uses to build and maintain indexes called?
-7
votes
2answers
116 views

I have table with 17 Indexes if i add 1 more index for search in two columns [closed]

I have table with 17 Indexes if i add 1 more index for search in two columns insert , update and delete queries will be slow.I dont want them to slow...what to do