General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thank's I'll get a try using a view, because of large dataset (more than 1 000 000 enreg.) I don't know the time neede by the parametrized view to extract the data needed, the time needed to refresh the view and so on.
I previously use SET FILTER because you've got nothing to do, and if you put your index after your filter it is very fast.
I've got a table which containing different type of people, like prospect customer and so, by this way when I need to create the view, I need to create a big cursor containing more than 200 000 line, I'm afraid about the time the query should take to extract these data.
Roman
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only