Thanks.

any other inputs?

pls find the attached documents.

🙂

any thoughts?

The post topic is System-R.

I am eager to now...any inputs?

Hello All,

I just refreshed all my posts.

This is a very old post (asked on 2009) 🙂

How to identify whether a code fall under O(n) / O (n2) / O(n log...

I thought Fried Rice 😀 & Egg Omlet 😛

is this a secret maintened by microsoft ? 🙂

I am asking "Out of Curiosity" to know the algorithm used by the engine.

whereever the optimizer sort the data, it sould use some algorothim to do this operation? Right?

My question is simple, is there any alogrithm used for ORDER BY clause or...

I have a table with 5 rows.

100

5

232

534453

23

No index has been created.

If I use ORDER BY , which alogirthm is used to do this sort operation?

5

23

100

232

534453

yes. You are correct. We have changed the same in UI. The date will come in the expected format in future. But for the existing one, I have to update...

few more thoughts ?

Gail,

You are right. The first one uses index seek and the second one uses "Table Scan". How? I used the indexed column only. Um..I guess..The optimizer choose "TableScan" as...

hum...interesting...topic..discussion..alng with some snow fight...