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!

  • Congratulations strongm 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

Programmer
Jan 18, 2004
24
0
0
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?)
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top