Smarter way to do that

Hi

I'd need to select different dates (not times) from a table.

I did a

SELECT DISTINCT TRUNC(MYDATES) FROM MYTABLE And it gives:

01/01/2006
02/01/2006
03/01/2006

and so on as it should, but it is slow, since the table contains a lot of records.

It there any smarter and faster way to do that?

TIA Sandman

Inviato da X-Privat.Org - Registrazione gratuita http://www.x-privat.org/join.php Received on Fri Jun 23 2006 - 08:56:45 CDT