Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.oracle | Overblown overpriced overengineered SHIT | 2,288 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 2,092 of 2,288 |
| Tomislav Kokoska to All |
| Speed up Select distinct |
| 10 May 05 11:13:28 |
From: tkokoska@varteks.com What is the best way to speed up query looks like: SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5 = 5 cardinality of Column5 = 10 will create bitmap index o n column5 help to speed up above query?? --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca