I was wondering if this is true or not, can someone answer this? Say I have a table with 60,000 records in it, and I have a query where I want the data with an ID of 4000. I heard sql searches like so
1 - 60000 2 - 59999 3 - 59998 but if you have an index, it does it like 1 2 3 4 until it gets to the correct ID "Success is a journey, not a destination!!" Doug Brown ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
