Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

General Question about the Select Statement

Status
Not open for further replies.
aliiiish

aliiiish

Programmer
Joined
Dec 19, 2005
Messages
13
Location
CA
Hi,

I would like to know if there is an optimum number of indexes that can be used with the Select or if not, is there a way to find out.

Thanks for your help.

ASH
 
Sort by date Sort by votes

As far as I know, it is one for each table.


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
SSMS question
Replies
4
Views
2K
Sana Shazadi
S
SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
grnzbra
  • Locked
  • Question Question
Create Function Within IF statement.
Replies
4
Views
2K
mikrom
mikrom
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
920
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top