tag:blogger.com,1999:blog-2257062243512934022.post453231891473706583..comments2023-10-31T18:51:23.836+05:30Comments on Sachin Arora's Blog: Index usage with LIKE operatorSachinhttp://www.blogger.com/profile/04551992629821526364noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2257062243512934022.post-91251623439478305662012-07-03T23:33:22.609+05:302012-07-03T23:33:22.609+05:30good explanation, thanksgood explanation, thanksDexterhttps://www.blogger.com/profile/18019352249440798065noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-10194892203548748582009-08-05T10:42:32.679+05:302009-08-05T10:42:32.679+05:30while doing a heavy insert block contention increa...while doing a heavy insert block contention increases.Because if a column has value like 10,11,12,13,..then there is a possibility that they will be inserted in contiguous blocks. Thus slowing insertion process.<br />By reversing the keys data will not be inserted in same or contiguous blocks..for example if we reverse the order of above numbers then they will become..01,11,21,31...so they will be inserted in diff blocks thus removing block contention..which will result in faster insertion of rows..Pankaj Bishtnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-15965799684847286202009-06-08T03:14:22.933+05:302009-06-08T03:14:22.933+05:30How about a Reverse Key iNDEX?How about a Reverse Key iNDEX?Anonymousnoreply@blogger.com