Re: [GENERAL] Help with order by into a RECORD

2005-04-01 Thread Richard Huxton
Shaun Clements wrote: Hi Richard I have a questions regarding my order by problem. If you index a table, can you query the table using ORDER BY. ? You can ORDER BY any combination of columns/expressions, whether they are indexed or not. An index may make things quicker (it isn't guaranteed to do

Re: [GENERAL] Help with order by into a RECORD

2005-04-01 Thread GIROIRE Nicolas (COFRAMI)
Title: FW: [GENERAL] Help with order by into a RECORD Yes, you can use ORDER BY on the table whiwh have an or several index.   Index allows to save time during execution of request. -Message d'origine-De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]De la part de

FW: [GENERAL] Help with order by into a RECORD

2005-04-01 Thread Shaun Clements
Title: FW: [GENERAL] Help with order by into a RECORD Hi I have a questions regarding my order by problem. If you index a table, can you query the table using ORDER BY. ? Kind Regards, Shaun Clements