10 Kicks

Force Index Scan on Table – Use No Index to Retrieve the Data – Query(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 2 years, 2 months ago

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan?

add a comment |category: |Views: 122

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
jeetjeet(0) - govindsyadavgovindsyadav(0) - KadiyalavjKadiyalavj(580) - subhashpuniasubhashpunia(35)
More who kicked this story...
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?