Structure of Example table:
I need to know if exists difference in performance between:
and
Or does not exists differences? |
My vote: no diff! answered 17 Nov '09, 12:00 Zote |
In version 10.0 and above, For expressions
I do not know of any reason why answered 10 Mar '10, 21:18 Ivan T. Bowman |
If the exact value is not important, but you just want to get an idea if 1000 or 1Mio entries exists you can use the super fast access to the column count of systab. This value is updated during each successful checkpoint.
Use case is for instance: The application wants to display total count of customers in the database in its status bar, updated every 5min... answered 11 Mar '10, 12:27 Martin Breck Carter @Breck: I wanted to correct "tabel_name", too, but seems unable to. Why don't I have an "edit" button for other people's post - am I still missing reputation in these times of boot-strapping? |