Hi. > You can't. > > Why are you trying to avoid the use of indices? Most people > like it when their indices make an ORDER BY go faster. And > why are you worried about duplicate data in a transient > table, as long as you are getting the correct answer? > Thanks for reply. Just in real query I has one constraint, usable for other index, and this index is are better. With using this index need process only 2000 records and sort it, and using other index need process 1000000 records and test it for constraint. And I can't change the structure of indexes, becose table is a virtual table from other data source.
So, I will try better calculate cost in my xBestIndex. WBR, Alexandr Orefkov. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
