vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I know that using indexing can increase the speed of queries. Keeping this in mind, Assuming i were to have a table with 4 fields.... Contract_Number, Status, Product_Code, Amount... Fields Contract_Number, Status & Product_Code are indexed. Q: If all data in field Status were to be populated with ACTIVE, would including the index of where 'Status = Active' still speed up the query? Thanks Yatin |