Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
3.50/5 (2 votes)
See more: , +
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.
Posted

1 solution

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.
[Edit]
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
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900