Re: oracle query

In article <95fcin$qgb$1_at_nnrp1.deja.com>,   Vadim Tropashko <vadimtro_at_yahoo.com> wrote:

> Just take a table big enough, say, all_people, and rewrite the query:
>
> select rownum as x from all_people
> where x*x=25

Didn't see anything less usefull in my life! Are you seriously suggesting to calculate square root that way?

> Your question is deeper than it sounds on the surface. The query above
> could be viewed as a formal declarative spec of what your program
> really wants, and query execution is just some not very efficient
> implementation. An exciting part comes when you discover that some
> RDBMS allow you to define your own indexes, so the query speed could
> definetely be improved. And that changes your view on what indexes
> really are completely. I'm not familiar with this topic in depth,
> however.

Yeah, right! You theoreticians cannot answer a single practical question and only offer some "insights" instead.

BTW, witty guy, try to query Greatest Common Divisor -- I've read that SQL is incomplete, so you cannot calculate anything your way.

Sent via Deja.com
http://www.deja.com/ Received on Sat Feb 03 2001 - 02:01:06 CET