--- Dawn Hollingsworth <[EMAIL PROTECTED]> wrote: > > > Currently we have a table with a sequence number( id > ) as a primary key, > a date field which is indexed and several other > columns. The user > interface allows the user to sort the data by date > and limits the result > set to 100 rows. > > The question is: > The user interface needs the capability to sort the > table by date but > pull out the hundred row set that contains id > say...542 for example. > > What would be the best way to do this taking into > account this table is > several hundred thousand rows?
try also to index the id. Try : Select * from <table> where id=<id> order by date limit <limit no> In this case you <limit no> is 100 since you want to return at most 100 rows. hope that helps. ludwig. __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
