Recent content by marist89

Not Windoz!

Give me a little credit. [/b] nope [/b] NUMBER(18) [/b] regular old b-tree [/b] composite. [/b] I could, but for this excercise, no. [/b] who said anything about order? If I had to order this beast, I'd have a sort_area_size of about 256M and it would come out in less than 2 seconds...

That's funny, I can get 850K records out of my database of 500M records in less then a second. Of course, I run Oracle.

Boy you guys like to write a lot of code. While you have to write 100's of lines of code, I have to SELECT * FROM tickData WHERE sample_dt > SYSDATE-10. Good luck to you.