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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

indexing on 2 fields

Status
Not open for further replies.
crystalReporterNew

crystalReporterNew

Programmer
Jan 18, 2004
24
US
Hi,
Is there any way I can create an index which indexes on field1 OR field2? (As opposed to a composite index which indexes like AND on both fields in the order specified?)
 
Sort by date Sort by votes
Hi ,
You will have to creat two seperate indexes for this.
So two non-clustered indexed should do the thing for you

Cheers
Parchure Nikhil
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raphael75
  • Locked
  • Question
installation errors on AWS Linux AMI
Replies
1
Views
149
raphael75
raphael75
bokswager
  • Locked
  • Question
modifying column on large table
Replies
0
Views
124
bokswager
bokswager
Carney123
  • Locked
  • Question
Indexing
Replies
1
Views
55
PDreyer
PDreyer
santhosh238
  • Locked
  • Question
Need script for finding out duplicate indexes on tables
Replies
1
Views
80
PDreyer
PDreyer
chinasyndrome
  • Locked
  • Question
2 db same name on 1 server, cant get right data
Replies
1
Views
97
chinasyndrome
chinasyndrome

Part and Inventory Search

Sponsor

Back
Top