Queries against indexes - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Queries against indexes

Author

Topic

heze
Posting Yak Master

192 Posts

Posted - 2006-04-03 : 15:31:23

Hi,
Based on the following query and assuming id is an indexed field:
--
select *
from MyTable
where id='1' and AnyField='something'
--
Can I say that I am querying MyTable against an indexed field?

On the other hand, if the sql is the following:
--
select *
from MyTable
where AnyField='something'
--
Can I say that I am querying MyTable against a non-indexed field?
----
In essence, when can we say that we query against an indexed field?

Thank you

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-04-03 : 16:20:09

You must be joking. What is this, the DBA kindergarten forum?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources