如何在不使用索引的情况下搜索数据 [英] how to search data without using index

问题描述

我在该项目中有一个项目，我想搜索数据而不使用索引&使用索引&我想显示它们之间的差异，我该如何在ado.net中做到这一点?请帮助我.

i have a project in that project i want to search data without using index & with using index & i want to show difference between them how can i do this in ado.net?? please help me.

推荐答案

这是一件非常简单的事情.创建有关列数，名称和类型的两个结构相同的表.一个表使用varchar列上的索引，而另一表则不使用.还要对具有数字类型的列执行此操作.您必须使用相同的数据加载两个表.为了使您的测量完整，还请注意在加载数据时的性能差异.

开始测量.如果您能与我们分享您的发现，我将不胜感激.

我建议使用SQL管理控制台创建表.
如果您需要开始使用C#和ADO.NET，请查看此教程: http://www .csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx [ ^ ].
[/编辑]
干杯！

—MRB

That is a very straight forward thing to accomplish. Create two structurally identical tables regarding number of columns, their names and their types. One table uses indices on a varchar column whereas the other table does not. Also do this for a column with a number type. You''ll have to load both tables with identical data. Just to make your measurements complete, please also note the performance difference while loading the data.

Let the measuring commence. I would very much appreciate it if you would share your findings with us.

I would recommend creating the tables using the SQL Management Console.
If you need to get started on C# and ADO.NET have a look at this tutorial: http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx[^].
[/Edit]
Cheers!

—MRB

这篇关于如何在不使用索引的情况下搜索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！