Efficient way to write Select

Question

How to write the following query in an efficient way.  The query might be hit thousands of time per day.

Select * from tablename where name like ('variablepassedhere')- where the table has millions of rows.

Thanks.

---

NSG12

Answer 1

Do you need all the fields to be returned? Do you want exact match or LIKE @Name + '%' ? In case of exact match you write = instead of LIKE.

In any case, the index on Name will speed this query up. There is nothing more you can do, I'm afraid.

 

---

Premature optimization is the root of all evil in programming. (c) by Donald Knuth

Naomi Nosonovsky, Sr. Programmer-Analyst

My blog

Answer 2

Thanks.

---

NSG12