One or more sessions could be in a delayed state waiting for rows to be inserted at the time you populate an unpopulated queue table. Without regard to fairness, Teradata Database reinstates 1 or more of those delayed sessions, up to the number of rows inserted into the table, to enable them to continue their consume mode requests.
| Session Mode | Use the following after any INSERT statements to make those rows visible to any delayed sessions |
|---|---|
| ANSI | COMMIT |
| Teradata |
|